Home » SQL & PL/SQL » SQL & PL/SQL » Can PL/SQL executed in shell ?
Can PL/SQL executed in shell ? [message #36518] Sun, 02 December 2001 23:03 Go to next message
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

----------------------------------------------------------------------

Report message to a moderator

Re: Can PL/SQL executed in shell ? [message #36537 is a reply to message #36518] Mon, 03 December 2001 09:39 Go to previous messageGo to next message
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

----------------------------------------------------------------------

Report message to a moderator

Re: Can PL/SQL executed in shell ? [message #38938 is a reply to message #36518] Wed, 29 May 2002 07:20 Go to previous message
avdprasad
Messages: 2
Registered: May 2002
Junior Member
want to know how can I post a question and my question is If I need to give parameters to the sql file.. how to give it in shell script

Report message to a moderator

Previous Topic: SQL statement help for date parameters
Next Topic: The trigger still not work, Does anyone can help please
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 00:40:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.