Home » Other » 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
ashais
Messages: 3
Registered: December 2007
Junior Member
Hi,

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.

Thanks,

Ashutosh
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
rleishman
Messages: 3728
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:

BEGIN
  my_procedure(args...);
END;

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: Thu Mar 28 21:18:01 CDT 2024