Can PL/SQL executed in shell ? [message #36518] |
Sun, 02 December 2001 23:03 |
diaz
Messages: 58 Registered: October 2001
|
Member |
|
|
hi,
i'm just know a bit about PL/sQL
i want to ask, if we build some procedure with PL/SQL can we call the procedure from the shell/prompt like we call SQL*Loader from shell/prompt ??
Thanks
----------------------------------------------------------------------
|
|
|
Re: Can PL/SQL executed in shell ? [message #36537 is a reply to message #36518] |
Mon, 03 December 2001 09:39 |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
you can call sqlplus from shell prompt
sqlplus username/password@cstring @ss.sql
write your procedure calling stmt in script file (ss.sql)
exec proc_name
----------------------------------------------------------------------
|
|
|
|