Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: passing values to a procedure from sql prompt

Re: passing values to a procedure from sql prompt

From: todor <delphi11i_at_yahoo.com.nospammingplease>
Date: Tue, 14 May 2002 09:28:31 -0700
Message-ID: <abrdvg$aun$1@news.Stanford.EDU>


sql>
begin

   myprocedure(myparameter => myvalue);
end;
/

or

exec myprocedure(myparameter => myvalue);

"raghav" <raghav_at_amsoft.net> wrote in message news:717979a0.0205140741.781ef7eb_at_posting.google.com...
> Hi,
>
> I have a procedure, which takes some values. it compiles successfully
> without any errors. Now i want to pass the values manually to this
> procedure from sql prompt... how can i do that?
>
> please help
>
> thanks in advance.
>
> -Raghav
Received on Tue May 14 2002 - 11:28:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US