Receiving error when executing a Sybase procedure in JBEDS

Solution Verified - Updated -

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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In