Home » SQL & PL/SQL » Client Tools » Running a procedure in sql*plus
Running a procedure in sql*plus [message #432336] Mon, 23 November 2009 11:33 Go to next message
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 #432338 is a reply to message #432336] Mon, 23 November 2009 11:48 Go to previous messageGo to next message
BlackSwan
Messages: 24915
Registered: January 2009
Senior Member
HUH?


You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

Post Operating System (OS) name & version for DB server system.
Post results of SELECT * from v$version.

SQL> EXEC YOUR_PROCEDURE;
Re: Running a procedure in sql*plus [message #432356 is a reply to message #432338] Mon, 23 November 2009 16:19 Go to previous messageGo to next message
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
Re: Running a procedure in sql*plus [message #432505 is a reply to message #432356] Tue, 24 November 2009 10:02 Go to previous message
californiagirl
Messages: 79
Registered: May 2007
Member
Thanks that was very helpful!

Californiagirl
Previous Topic: Additional new lines in SQL script file and problem with SQL*Plus
Next Topic: TNS-12154 could not resolve the connect identifier specified
Goto Forum:
  


Current Time: Sat Oct 01 00:22:37 CDT 2016

Total time taken to generate the page: 0.09955 seconds