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

Thanks a lot.

I just know that there is such a thing called cursor :)

The stored proc looks fine now.

Paul

On Dec 29, 8:48 am, "Paul" <plch..._at_gmail.com> wrote:
> 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 -- Hide quoted text -- Show quoted text -
Received on Thu Dec 28 2006 - 19:13:53 CST