|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Procedure in SQL*plus
Hi There,
I am new to this forum.You guys do an awesome job here. I have a question on procedures. Can anyone tell me how do I run a procedure from SQL*plus so that changes take place in database. And also how do I run the procedure from Unix BSH(Bash shell). Any help appreciated. Thanks, Nisha. |
|
#2
|
|||
|
|||
|
The 'how to run from unix' question is answered frequently here. Search for it in the forums - search for the word exsql - it's in one the examples I've posted about 6 times in two weeks.
You have a script file called script.sql, to run it once you are inside sqlplus: Code:
@script |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > Procedure in SQL*plus |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|