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]>
