Error message when trying to call Oracle stored procedure from MSSQL

From: Eric Levinson <nospam_at_nospam.com>
Date: Fri, 18 Oct 2002 17:56:46 GMT
Message-ID: <yXXr9.41754$Ik.913603_at_typhoon.sonic.net>

[Quoted] I'm trying to use the EXEC command in ODBC to call an oracle stored procedure. The error message is below. I don't understand where it is getting the '1' from.

Any ideas?

Thanks,
Eric

[OLE/DB provider returned message: [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-06550: line 1, column 46:
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 "if was inserted before "1" to continue] Received on Fri Oct 18 2002 - 19:56:46 CEST