Re: pl/sql refcursor

first......i don't need to write all code for you...... replace your select statement by what you want........

we have a support contract, but i don't have the time to send a itar each times
i found a BUG.......but for THIS BUG ....i was send a itar when the odbc driver

was 8.1.7.2........and THIS BUG was fixe in the 8.1.7.4 version with MY
ITAR..........
thank you...

i send a exemple to help you to know how return to recordset.......this is the easy way to do it.
if its too complicated for you.........found a solution yourself.........

i don't accept any frustration from anybody.......... ciao!!!!!!!!1

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:itrugus0f2m15i0g8tn87r5t97or3triad_at_4ax.com...
> On Tue, 18 Jun 2002 09:47:52 -0400, "Sylvain Dumont"
> <sylvain_dumont_at_karat.com> wrote:
>
> >do something like that.!!
> >
> >CREATE OR REPLACE PACKAGE KSP_PLSQLRSETPKG
> > AS
> >TYPE RCT1 IS REF CURSOR;
> >END;
> >;
> >
> >the first parameter "oraclebug" is to bypass the oracle bug doesn't
accept a
> >string for the first parameters
> >when in the odbc tab sqlserver migration is on
> >
> >CREATE OR REPLACE PROCEDURE KSP_TEST
> > ( ORACLEBUG INT DEFAULT 0,
> >RC1 IN OUT KSP_PLSQLRSETPkg.RCT1,
> >RC2 IN OUT KSP_PLSQLRSETPkg.RCT1
>
>
> REF CURSORs should be OUT parameters.
> Do you think when you know so little about Oracle, you are justified
> to shout 'bug' in all your posts. This is just crappy code and nothing
> more.
> If you think it is a bug, why don't you submit an Itar? No Support
> Contract, I guess. I have been wading on your behalf through Metalink
> and couldn't find any reference to your 'bug'.
> I now see you are just running crappy code. A ref cursor is a cursor,
> and you can't assign it a string parameter. PERIOD.
> Please stop posting your unfounded accusations and start learning
> Oracle.
>
> Regards
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Tue Jun 18 2002 - 12:57:55 CDT