problem calling Stored Procedure from Access

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 - 12:53:45 CEST