March 29, 2002 at 8:48 am
I am trying to execute an oracle stored procedure through a linked server and I am getting the following error:
Server: Msg 7212, Level 17, State 1, Line 1
Could not execute procedure 'ERIC' on remote server 'TOM'.
[OLE/DB provider returned message: ORA-06550: line 1, column 30:
PLS-00103: Encountered the symbol "1" when expecting one of the following:
begin declare end exception exit for goto if loop mod null
pragma raise return select update while <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall
<a single-quoted SQL string>
The symbol "return" was substituted for "1" to continue.]
Anyone seen this, or know how to resolve the problem.
The stored procedure is just deleting some rows and returning success or failure.
Thanks
Tom Goltl
April 1, 2002 at 9:08 am
Can you post the code you are using and the paramteres of the Oracle Procedure. Also I don't know of a way you can create the variable for oracle to return your results thought from an Oracle Procedure due to the way they are returned normally.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 1, 2002 at 3:06 pm
You hit it on the head. After much research and work we have concluded that this cannot be done. We're now trying to do it with an oracle function and have gotten better results with that.
Thanks for the response.
Tom Goltl
April 1, 2002 at 3:25 pm
Great to hear you are at least finding a way.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply