Paul,
From the error message, it appears you are using the Microsoft ODBC Driver for Oracle. The code in the specified message can only be used with the Oracle ODBC Driver. Can you change drivers in your environment? If not, you can get an example of using the MS driver from MSKB#
Q221189.
HTH.
>Hi Mark,
>
>I want to return a string, like 'Update successful.' from my Oracle stored procedure. I saw the plsql code in the message #
631727.
>
>I had a look at the thread you mentioned below. My clients are using the MS Oracle ODBC driver.
>
>I tried the ReturnCursor procedure that you and Larry talked about in other messages. I got the following odbc error message:
>
>***************************************
>Connectivity error: [Microsoft][ODBC driver for Oracle][Oracle]ORA-06550: line 1, column 53:
>PLS-00103: Encountered the symbol "OUT" when expecting one of the following:
>
> . ( ) , * @ % & | = - + < / > at in mod not range rem => ..
>
>*********************************************
>
>Am I out of luck??
>
>Paul
>
>
>
>>To return a cursor you need an Oracle package. See:
>>
>>Re: Newbie question re: PL/SQL conditional code Thread #625442 Message #631727
>>
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao