Home » SQL & PL/SQL » SQL & PL/SQL » creating procedure or function with no parameter
creating procedure or function with no parameter [message #37286] Tue, 29 January 2002 10:05 Go to next message
epro
Messages: 11
Registered: January 2002
Junior Member
is is possible to create a procedure with no parameter,
if so could you please share with us.
Re: creating procedure or function with no parameter [message #37287 is a reply to message #37286] Tue, 29 January 2002 11:25 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
create or replace procedure no_parameters
is
begin
  --some code here
end;
/
 
create or replace function f_no_parameters
  return varchar2
is
begin
  -- some code here
  return (null); -- something
end;
/
Previous Topic: Re: SQL TUTORIAL.
Next Topic: Re: PLS-00201: identifier 'BRANCH.BRANCH' must be declared
Goto Forum:
  


Current Time: Sat May 30 07:52:04 CDT 2020