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
ashais
Messages: 3
Registered: December 2007
Karma: 0
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: 3727
Registered: October 2005
Location: Melbourne, Australia
Karma: 0
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: ERD tool
Next Topic: developer sql
Goto Forum:
  


Current Time: Tue Aug 22 13:49:05 CDT 2017

Total time taken to generate the page: 0.10129 seconds