Re: plsql fuction [message #20870] |
Wed, 26 June 2002 20:48 |
santosh
Messages: 85 Registered: October 2000
|
Member |
|
|
Hello epe
Thanks for showing ur responce to attempt to solve my problem.I really appreciate your help. But unfortunately the solution doesnt solve the purpose as u know when u do @path/programname.sql it will compile the program present and create the procedure in the database. But as i said earlier the procedure is already stored there in the database and i need to execute it through batch file.
I already tried the way u have shown but by using command as
c:oracleora81binsqlplus.exe
exec mymessage('santosh') -- here myproc just return simple 'hello santosh' message for trial
if I include second line nothing happens.
If i remove second line new sqlplus application opens.
I expect u to be more helpful to me in this regards
Thanks
Santosh
|
|
|