OraFAQ Forum: Client Tools » How i can Run a Procedure only from API

Home » Other » Client Tools » How i can Run a Procedure only from API (Oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How i can Run a Procedure only from API [message #288246]

Sun, 16 December 2007 05:34

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

Report message to a moderator

Re: How i can Run a Procedure only from API [message #288270 is a reply to message #288246]

Sun, 16 December 2007 20:15

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 18 08:29:01 CST 2025