[ 
http://issues.apache.org/jira/browse/IBATIS-178?page=comments#action_12317814 ] 

Sven Boden commented on IBATIS-178:
-----------------------------------

Do you have some more information like sqlmaps or so, else it's pretty hard to 
comment on the error.

It can't be a reserved keyword issue, iBATIS does not parse its output 
parameters where you get the exception.

If I would have to make a hunch... Can you run the query you try to run via 
SQL*plus and additionally run the same query but also request the length of the 
field.... and report back the length of the "ELEMENT output". If my hunch is 
correct  you could be trying to return more characters that fit varchar, and 
then you could get in the CLOB area which is then probably not supported by the 
type you specified.

Regards,
Sven

> Return value of "ELEMENT" in a Stored Procedure OUT parameter returning an 
> error
> --------------------------------------------------------------------------------
>
>          Key: IBATIS-178
>          URL: http://issues.apache.org/jira/browse/IBATIS-178
>      Project: iBatis for Java
>         Type: Bug
>   Components: SQL Maps
>     Versions: 2.0.9b
>  Environment: XP, Oracle database
>     Reporter: Ramil Odvina

>
> Error occurring during a basic call to a stored procedure if one of the OUT 
> parameters returns the value of "ELEMENT", all caps.  Looks like a reserve 
> keyword issue.  All other values seem to work fine.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

Reply via email to