You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Ramil Odvina (JIRA)" <ib...@incubator.apache.org> on 2005/08/01 16:21:36 UTC
[jira] Created: (IBATIS-178) Return value of "ELEMENT" in a Stored Procedure OUT parameter returning an error
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
[jira] Closed: (IBATIS-178) Return value of "ELEMENT" in a Stored Procedure OUT parameter returning an error
Posted by "Clinton Begin (JIRA)" <ib...@incubator.apache.org>.
[ http://issues.apache.org/jira/browse/IBATIS-178?page=all ]
Clinton Begin closed IBATIS-178:
--------------------------------
Resolution: Invalid
No further details after 2 months...must have found the problem.
> 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
[jira] Commented: (IBATIS-178) Return value of "ELEMENT" in a Stored Procedure OUT parameter returning an error
Posted by "Sven Boden (JIRA)" <ib...@incubator.apache.org>.
[ 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
[jira] Commented: (IBATIS-178) Return value of "ELEMENT" in a Stored Procedure OUT parameter returning an error
Posted by "Ramil Odvina (JIRA)" <ib...@incubator.apache.org>.
[ http://issues.apache.org/jira/browse/IBATIS-178?page=comments#action_12317334 ]
Ramil Odvina commented on IBATIS-178:
-------------------------------------
Here is the error:
org.springframework.jdbc.UncategorizedSQLException: (SqlMapClient operation): encountered SQLException [
--- The error occurred in com/netlook/dao/ibatis/maps/VinDecode.xml.
--- The error occurred while applying a parameter map.
--- Check the VinDecode.vinDecodeParameters.
--- Check the output parameters (retrieval of output parameters failed).
--- Cause: java.sql.SQLException: Invalid column type: getCLOB not implemented for class oracle.jdbc.driver.T4CVarcharAccessor]; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/netlook/dao/ibatis/maps/VinDecode.xml.
--- The error occurred while applying a parameter map.
> 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