problem calling Stored Procedure from Access

From: You Know You're Right <vijay.nagar_at_vichara.com>
Date: 2 Jun 2004 03:53:45 -0700
Message-ID: <141fee71.0406020253.2ce19001@posting.google.com>

Hi,

I connect Access 2000 to Oracle 9.2 using ODBC. I called a stored procedure from the access VBA interface which included a Date argument. everything is fine with the procedure cose it was compiled well, but i have been having this problem....

[Oracle][ODBC][Ora]ORA-06550: line 1, column 66: PLS-00103: Encountered the symbol "" when expecting one of the following:

begin case declare end exception exit for goto if loop mod null pragma raise return select update while with
<an identifier> <a double-quoted delimited-identifier>
<a bind variable> << close current delete fetch lock insert
open rollback savepoint set sql execute commit forall merge
<a single-quoted SQL string> pipe

The symbol "" was ignored.

Thanks in anticipation.. Received on Wed Jun 02 2004 - 05:53:45 CDT