Receiving error when executing a Sybase procedure in JBEDS
Issue
- We are connecting to a Sybase database using the JConnect Sybase driver in JBEDS.
- When we try to execute a procedure we receive the following error:
[TeiidException] ZZZZZ: Error Code:ZZZZZ Message:Remote org.teiid.translator.TranslatorException: Error Code:ZZZZZ Message:'{ call COP2_Mission_Location;1(?)}' error executing statement(s): {1}
1 [SQLException]Remote java.sql.SQLException: Execute cursor 'jconnect_implicit_4' is declared on a procedure which contains a non-SELECT or a SELECT with a COMPUTE clause. For the declaration of this cursor to be legal it should have a single SELECT statement without a COMPUTE clause.
Environment
- JBoss Enterprise Data Services (JBEDS) 5.2.0
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.