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
>