Re: a simple PL/SQL question about getting a list of values to output parameters

Thanks a lot all.

What I have been asked to do is just grabbing some simple information from DB. I am an application developer and get used to embedded sql, but my new company policy only allows stored proc (admin reason) and that's something I don't know. That's why I am trying to ask and see how I can do this simple thing in stored proc quickly.

Paul

On Dec 29, 8:02 am, "hpuxrac" <johnbhur..._at_sbcglobal.net> wrote:
> Paul wrote:
> > Hi,
>
> > I am newbie to PL/SQL and have a problem of passing OUT parameters.
>
> > If I have a procedure like this:
>
> > ========================
> > CREATE OR REPLACE PROCEDURE MYPROC (myinput IN varchar2, output1 out
> > varchar2, output2 out varchar2)
> > AS
> > BEGIN
> > select field1, field2 into output1, output2 from mytable where
> > field3 like myinput;
> > END MYPROC
>
> > ========================
>
> > The sql statement returns more than one row from "mytable". I found
> > that everytime when I try to invoke the procedure the "output1" and
> > "output2" never give me anything, just NULL value.
>
> > What is the correct way to get that two fields?
>
> > Thanks a lot.
>
> > PaulSelect into is a construct best avoided. Look at using oracle tables
> and bulk select capabilities.- Hide quoted text -- Show quoted text -
Received on Thu Dec 28 2006 - 18:48:06 CST