Tom,
what about putting a comma to separate the parameters in the SP call ?
Best regards,
---------------------------------------------
Luca Morandini
GIS Consultant
[EMAIL PROTECTED]
http://utenti.tripod.it/lmorandini/index.html
---------------------------------------------
> -----Original Message-----
> From: Tom Shepherd [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 08, 2002 7:08 PM
> To: [EMAIL PROTECTED]
> Subject: Accessing Oracle Stored Procedures
>
>
> I am using esql on Cocoon 2.0.3 to run a stored procedure with multiple 'IN'
>parameters on an Oracle 8.1.7 database but
> without success. I have run other procedures on the same database which have a
>single 'IN' parameter without any problem.
> I have also altered my 'problem' procedure to have a single 'IN' parameter and all
>is OK so I know the procedure if fine.
>
> The esql code I am using is as follows:-
>
> <esql:call>{call suggestion.enterSuggestion(
> <esql:parameter direction="in"
>type="String"><xsp:expr>exprOne</xsp:expr></esql:parameter>
> <esql:parameter direction="in"
>type="String"><xsp:expr>exprTwo</xsp:expr></esql:parameter>
> )}</esql:call>
>
> (I am using this within the standard <esql:execute-query> structure).
>
> I always get the same error:-
>
> ORA-06550: line 1, column 38: PLS-00103: Encountered the symbol "" when expecting
>one of the following: . ( ) , * @ % & |
> = - + < / > at in mod not range rem => .. <an exponent (**)> <> or != or ~= >= <= <>
>and or like as between from using is
> null is not || indicator is dangling The symbol "," was substituted for "" to
>continue.
>
> Can anyone help?
>
>
> --
>
> This e-mail may contain confidential and/or privileged information. If you are not
>the intended recipient (or have
> received this e-mail in error) please notify the sender immediately and destroy this
>e-mail. Any unauthorized copying,
> disclosure or distribution of the material in this e-mail is strictly forbidden.
>
>
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail: <[EMAIL PROTECTED]>
>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
