Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Call Oracle store procedure
Message
 
 
To
26/06/2002 21:41:08
Paul De Niverville
Deniverville Econometric Research Ltd.
Victoria, British Columbia, Canada
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00647076
Message ID:
00672868
Views:
27
I would need you to post your Stored Proc code before I could tell you what the problem is.

>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??
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform