Home » SQL & PL/SQL » SQL & PL/SQL » Re: plsql fuction
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
Previous Topic: select logic
Next Topic: select a set of records
Goto Forum:
  


Current Time: Sat Jul 20 21:58:23 CDT 2019