Oracle Apps - Which command is used to execute a store procedure?

GeekInterview.com > Interview Questions > Oracle Apps

Go To First | Previous Question | Next Question

Oracle Apps | Question 2 of 61

Which command is used to execute a store procedure?

Total Answers and Comments: 7

Last Update: October 03, 2007 Asked by: Aminur

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

November 11, 2005 05:35:59

gomathi

RE: which command is used to execute a store procedure...

exec ;

Is this answer useful? Yes | No

December 19, 2005 07:05:03

Gudala

RE: which command is used to execute a store procedure...

SQL> exec <proc name>;

Is this answer useful? Yes | No

January 24, 2006 04:00:42

shiv

RE: which command is used to execute a store procedure...

sql>exec <procedure_name>(values of IN parameters)

Is this answer useful? Yes | No

January 30, 2006 10:58:08

vidhya165

Member Since: January 2006 Contribution: 13

RE: which command is used to execute a store procedure...

sqlprompt>exec <procedure name> <parameter list if necessary>;

Is this answer useful? Yes | No

March 07, 2006 01:30:35

Mukesh babu

RE: which command is used to execute a store procedure...

begin

procedurename(parameters.....);

end;

Is this answer useful? Yes | No

April 19, 2007 08:06:20

Narender

RE: Which command is used to execute a store procedure...

execute <procedure_name>

Is this answer useful? Yes | No

October 03, 2007 13:47:23

shrikantgarud

Member Since: September 2007 Contribution: 6

RE: Which command is used to execute a store procedure...

dealing with packages and procedures
we use

sql> package_name.procedure_name(pass the parameter here)

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank