Home » SQL & PL/SQL » Client Tools » How i can Run a Procedure only from API (Oracle 9i)
How i can Run a Procedure only from API [message #288246] Sun, 16 December 2007 05:34 Go to next message
Messages: 3
Registered: December 2007
Junior Member

I want to run a customer API's solo procedure with parameters indepently.

How can i do that?

i want to run one procedure and even the total API with my defind parametres in TOAD to test whether API is creating the right result.

If anybody has exp, please let me know with suitable example.

Thanks in Advance.

Mail me to ashu12ka4@rediffmail.com.


Re: How i can Run a Procedure only from API [message #288270 is a reply to message #288246] Sun, 16 December 2007 20:15 Go to previous message
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
If your SQL client tool can submit PL/SQL, then enclose it in an anonymous PL/SQL block:


If your client supports SQL only, you can use the CALL statements:

CALL my_procedure(args...);

The Oracle PL/SQL Guide is a good place to start learning. There's also a great tutorial in the 11g documentation.

Ross Leishman
Previous Topic: How can i convert database from SQL server to Oracle?
Next Topic: Getting error when startup SQL Navigator 3
Goto Forum:

Current Time: Sat Oct 22 07:41:17 CDT 2016

Total time taken to generate the page: 0.13130 seconds