ibatis-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sven Boden (JIRA)" <ibatis-...@incubator.apache.org>
Subject [jira] Commented: (IBATIS-178) Return value of "ELEMENT" in a Stored Procedure OUT parameter returning an error
Date Fri, 05 Aug 2005 19:41:35 GMT
    [ 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


Mime
View raw message