Procedure type definition [message #440310] |
Fri, 22 January 2010 06:27  |
Hitman11
Messages: 94 Registered: October 2009 Location: norway
|
Member |
|
|
Hi all,
Can somebody explain the use/difference of below procedures?
1.CALL bala.proc1(argument1,argument2,argument3,argument4...);
2.execute procedure('argument');
Regards,
|
|
|
|
|
Re: Procedure type definition [message #440315 is a reply to message #440310] |
Fri, 22 January 2010 07:02   |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
SQL> create or replace procedure p is begin null; end;
2 /
Procedure created.
SQL> exec p;
PL/SQL procedure successfully completed.
SQL> call p;
call p
*
ERROR at line 1:
ORA-06576: not a valid function or procedure name
SQL> call p();
Call completed.
In the short way, just a difference in syntax.
Regards
Michel
[Updated on: Fri, 22 January 2010 07:04] Report message to a moderator
|
|
|
|
|
|
|
|
Re: Procedure type definition [message #440323 is a reply to message #440321] |
Fri, 22 January 2010 07:15  |
 |
ramoradba
Messages: 2457 Registered: January 2009 Location: AndhraPradesh,Hyderabad,I...
|
Senior Member |
|
|
Yes no need of CALL (we can ignore in that case)....
ind> call p();
Call completed.
ind> ed
Wrote file afiedt.buf
1 begin
2 call p();
3* end;
4 /
call p();
*
ERROR at line 2:
ORA-06550: line 2, column 12:
PLS-00103: Encountered the symbol "P" when expecting one of the following:
:= . ( @ % ;
The symbol ":=" was substituted for "P" to continue.
ind> ed
Wrote file afiedt.buf
1 begin
2 p();
3* end;
ind> /
PL/SQL procedure successfully completed.
SO Mr Hitman Better read the documents..which are provided for each and every post of you....
Good luck
sriram
[Updated on: Fri, 22 January 2010 07:18] Report message to a moderator
|
|
|