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

Home -> Community -> Usenet -> c.d.o.server -> Re: EXEC syntax for SP which returns row set

Re: EXEC syntax for SP which returns row set

From: Mark A <nobody_at_nowhere.com>
Date: Fri, 15 Jul 2005 20:19:02 -0600
Message-ID: <YIydnco2ZOYO80XfRVn-jg@comcast.com>


<fitzjarrell_at_cox.net> wrote in message
news:1121478509.051291.146710_at_g49g2000cwa.googlegroups.com...
>
> Yet it doesn't compare to the stored procedure shown above, which does
> have an OUT parameter, even though you refuse to admit the fact.
> Please show us a DB2 stored procedure, coded with an OUT parameter just
> as the Oracle sample you've provided, and show us how you can call it
> without passing the required variables.
>
> David Fitzjarrell
>

I don't understand your point. The DB2 example has a return cursor like the Oracle SP, and neither has any other OUT parm.

Obviously, you consider the return cursor in the Oracle SP an out parm. So what? What is your point? Received on Fri Jul 15 2005 - 21:19:02 CDT

Original text of this message

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