OraFAQ Forum: SQL & PL/SQL » creating procedure or function with no parameter

Home » SQL & PL/SQL » SQL & PL/SQL » creating procedure or function with no parameter

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

creating procedure or function with no parameter [message #37286]

Tue, 29 January 2002 10:05

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.

Report message to a moderator

Re: creating procedure or function with no parameter [message #37287 is a reply to message #37286]

Tue, 29 January 2002 11:25

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;
/

Report message to a moderator

Previous Topic:	Re: SQL TUTORIAL.
Next Topic:	Re: PLS-00201: identifier 'BRANCH.BRANCH' must be declared

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 08:49:26 CDT 2024