executing a procedure from within an anonymous pl/sql block

[jimmy80]

Hi I was wondering if anyone could help...
I'm trying to execute a stored procdure from within an anonymous pl/sql block.. something like
Declare
var1 NUMBER;
BEGIN
execute test_procedure ('param1', 'param2');
END;
but I get the a pl/sql error "expecting symbol :=, ...."

Is it possible to execute the procedure from within the pl/sql block and if so any ideas on what I'm doing wrong?

Thanks for your time,
Jimmy

 

[lewisp]

Jimmy,

What you need is simply

[tt]Declare
var1 NUMBER;
BEGIN
test_procedure ('param1', 'param2');
END;
[/tt]

 

[sem]

In fact execute command just wraps your procedure call in begin/end to get correct anonymous pl/sql block:

exec test <=> begin test; end;

Regards, Dima

 

[shahzadzafar]

hi jimmy,
when u r calling a stored procedure in pl/sql block then
there is no need of EXECUTE command ,it is used at that time when u execute a SP on sql propmt.
Simply use.....

begin
test_procedure('param1','param2');
end;
Thanks..
Regards
Shahzad Zafar