hi ,
I tried running a PL/SQL script through unix shell script.
But am getting the following error.
"Message file sp1<lang>.msb not found
Error 6 initializing SQL*Plus "
Kindly suggest.
Regards,
Samit
Can you post a sample of your code, preferably where you call SQL PLUS and pass in your statement. The error that you are getting is most likely caused by the ORACLE_HOME variable not being correctly set. Also, check other Oracle related variables such as ORACLE_SID, and your ID and password.
edit - See the Oracle FAQ
Hi,
I have a requirement whereby I have to sort a flat file based on Multiple Columns (similar to ORDER BY Clause of Oracle). I am getting 10 columns in the flat file and I want the file to be sorted on 1st, 3rd, 4th, 7th and 9th columns in ascending order. The flat file is pipe seperated.
Any help will be highly appreciated.
Thanks,
Dharmesh
Um, I guess your Oracle error was resolved?
yeah ,
the oracle error is resolved.........