Search Results

ooooppss, my bad

the proc is working fine, i greatly appreicate all your help, thanks a lot

i have removed the validation and giving only the procedure call as input. but giving an error, can some one please check?


SQL> Connected.
SQL> SQL> SQL> 2 3 4 5 6 7 8 9...

Your reply is appreciated, i guess i haven't explain the problem clearly. let me brief it again. Below is my complete list of shell program, all it does is execute the sql procedure and creates a log...

Thanks for the reply, my proc executes always in sqlplus without any issues, not sure why unix code gives error...


var xx varchar2(100);
SQL>...

Hello,
I have to call the stored procedure as argument from the unix shell program. Looks like unix doesnt like, can someone comment pls

USERID=scott
PASSWD=xxxxxx
PLSQLCALL=$2

STDT=`sqlplus...