Which command is used to execute a store procedure?

Showing Answers 1 - 20 of 20 Answers

gomathi

  • Nov 11th, 2005
 

exec ;

  Was this answer useful?  Yes

Gudala

  • Dec 19th, 2005
 

SQL> exec <proc name>;

  Was this answer useful?  Yes

shiv

  • Jan 24th, 2006
 

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

  Was this answer useful?  Yes

Mukesh babu

  • Mar 7th, 2006
 

begin

procedurename(parameters.....);

end;

  Was this answer useful?  Yes

Narender

  • Apr 19th, 2007
 



 execute <procedure_name>

  Was this answer useful?  Yes

Bonthu Nagi Reddy

  • Mar 5th, 2012
 

Begin

execute BNR;

end;

Note:- "BNR" is the stored procedure name.

  Was this answer useful?  Yes

shiva

  • Apr 11th, 2012
 

There are two ways to execute the stored procedure
1. EXEC
2. Create anonymous block
EX:
BEGIN

END;

IF procedure is declared in package then we have to call this procedure in following way:

.

If you are executing from SQLPlus then

SQL> execute procedurename(paramters); -- You can also use short format EXEC

If you are using PL-SQL then

BEGIN

procedurename(parameters); -- no need to use Execute keyword in PL-SQL block

END;

Thanks

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions