Home » SQL & PL/SQL » SQL & PL/SQL » Stored Procedure with no Parameters
Stored Procedure with no Parameters [message #7725] Thu, 03 July 2003 02:55 Go to next message
Juergen
Messages: 7
Registered: August 2002
Junior Member
Hi,

How can I execute a SP with no parameters?

execute SP_Name
execute SP_Name ()

is not working

Thanks
Re: Stored Procedure with no Parameters [message #7729 is a reply to message #7725] Thu, 03 July 2003 04:43 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Execute should work in sql*Plus:
SQL> create procedure foo
  2  is
  3  begin
  4    dbms_output.put_line('foo has been executed');
  5  end;
  6  /

Procedure created.

SQL> set serverout on
SQL> execute foo
foo has been executed

PL/SQL procedure successfully completed.

SQL> begin
  2    foo;
  3  end;
  4  /
foo has been executed

PL/SQL procedure successfully completed.
MHE
Previous Topic: What is the difference between Oracle 8i and 9i
Next Topic: Error capturing
Goto Forum:
  


Current Time: Fri Apr 26 22:59:19 CDT 2024