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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content