0 LIKES LikeUnLike
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:
Latest activity: earlier. This question has 0 answers.