Issue while running UNIX shell script from Oracle concurrent Program
Did you happen to use an editor on a Windows system to create the script? It's puts a carriage return + line feed character at the end of every line instead of the Unix format of just having a line feed. That messes up the script execution. Unix systems usually have a command like "dos2unix" to convert the file.
If that's not it, I would try running the script manually from the command line to make sure it works.
When I tried to read the file using CAT -vt <filename>
, I could see that the file contains special characters such as ^M and ^I. This may be because of the file transfer mode(but I transferred in ASCII mode, still the special characters where appearing).
I opened a VI editor and pasted the same script. Save the file, tried to run the script, It was working fine.
I still didn't get how the special characters appeared. I used notepad++ as my editor.
When either VI or CAT displays specials characters, the conversion to Linux/Unix compatibility is not completely done. There's often many solutions, maybe Notepad++ is the cause here. Maybe not. Writing scripts on the OS itself, is not only faster (no need for FTP, which is already a big plus), but you don't have to face these annoying control-M characters. The ASCII conversion sometimes fails. You can also try another FTP program. Or avoid it all togheter, as mentioned above.