Running a procedure in sql*plus [message #432336] |
Mon, 23 November 2009 11:33  |
californiagirl
Messages: 79 Registered: May 2007
|
Member |
|
|
I want to test a procedure that I created in pl/sql and run it through sql*plus what command do I use for this method?
Also I have Toad 9.6.1 version, but can't I also run this procedure through toad? I have been running the cursor/sql part through toad, but I need to run the entire procedure through toad or sql*plus to test the procedure out...how would I accomplish this through toad..what are the steps??
Let me know.
Thanks
Californiagirl
[Updated on: Mon, 23 November 2009 11:36] Report message to a moderator
|
|
|
|
Re: Running a procedure in sql*plus [message #432356 is a reply to message #432338] |
Mon, 23 November 2009 16:19   |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
Pretty simple really. Toad > help > search "Calling Stored Procedures"
If you are familiar with SQL plus, then just set up the anonymous PL/SQL with all your other SQLplus commands (like set serveroutput on) in the SQL editor, then Editor > Execute SQL via SQL*Plus
|
|
|
|