Question:

SQL Invalid cursor number 135 error

by  |  earlier

0 LIKES UnLike

We are having this error as given below when we are running are schedule job.The message which appears on the log file is given below. I dont know what SQL 135 Invalid cursor means.Could you please give us some information regarding this issue.SQL ERROR INFORMATION=====================CODE [DB0101]TEXT [SQL 135 - Invalid cursor number.]DESCRIPTION-----------Centura Error: 135Centura Message: Invalid cursor numberCentura Function: sqlcom (compile statement)Native Error: 0Native Message: STATEMENT---------SELECT TRANSACTION_TYPE FROM TRANS_HISTORY WHERE LINK_NUMBER = :1 AND ACCT_ID= :2 AND CLASS = :3 AND UNIT_NUMBER = :4 AND CERTIFICATE_NUMBER = :5 AND TRANSACTION_AMOUNT> 0 ORDER BY EFFECTIVE_DATEERROR MESSAGE=============SQL error 135 in User Function 201296/SQL 4 (selTransactionType)- function/info vWe are having this error as given below when we are running our schedule job.The message which appears on the log file is given below. I dont know what SQL 135 Invalid cursor means.Could you please give us some information regarding this issue.SQL ERROR INFORMATION=====================CODE [DB0101]TEXT [SQL 135 - Invalid cursor number.]DESCRIPTION-----------Centura Error: 135Centura Message: Invalid cursor numberCentura Function: sqlcom (compile statement)Native Error: 0Native Message: STATEMENT---------SELECT TRANSACTION_TYPE FROM TRANS_HISTORY WHERE LINK_NUMBER = :1 AND ACCT_ID= :2 AND CLASS = :3 AND UNIT_NUMBER = :4 AND CERTIFICATE_NUMBER = :5 AND TRANSACTION_AMOUNT> 0 ORDER BY EFFECTIVE_DATEERROR MESSAGE=============SQL error 135 in User Function 201296/SQL 4 (selTransactionType)- function/info values = DB_Compile/noneRegards,JawadGESB Australia..

 Tags:

   Report
Please Login to view 0 answers to this question
SIMILAR QUESTIONS
CAN YOU ANSWER?

Question Stats

Latest activity: earlier.
This question has 0 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.