Question about Gupta Team Developer for PC

2 Answers

SQL Invalid cursor number 135 error

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: 135
Centura Message: Invalid cursor number
Centura Function: sqlcom (compile statement)
Native Error: 0
Native 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_DATE



ERROR MESSAGE
=============

SQL error 135 in User Function 201296/SQL 4 (selTransactionType)
- function/info v We 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: 135
Centura Message: Invalid cursor number
Centura Function: sqlcom (compile statement)
Native Error: 0
Native 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_DATE



ERROR MESSAGE
=============

SQL error 135 in User Function 201296/SQL 4 (selTransactionType)
- function/info values = DB_Compile/none


Regards,
Jawad
GESB
Australia..

Posted by on

  • Raph30 May 11, 2010

    Hello,

    Can you please specify what platform and application the sql error is being generated?


    Also, are the same number of fields being passed to this statement from the cursor?


    Thank You,
    Raphael

×

2 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Social Spider:

    An expert who has shared 50 answers on their Facebook wall.

  • Expert
  • 43 Answers

I think the problem is caused by the line of code:DB.Close
(7 lines from the end of your function).
Try commenting out the call to DB.Close

Posted on Jun 09, 2016

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 258 Answers

The error is being generated because you are trying to order on a value not in your selected fields e.g EFFECTIVE_DATE

You only have TRANSACTION_TYPE in your select statement

Posted on Feb 10, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

4 Answers

How to Fix Connection Issues in Microsoft SQL Server?


RecoveryFix for MS SQL database recovery software tool is an easy-to-use, more interactive and self-descriptive software for users who are looking to repair and retrieve .mdf files. You can try this software: http://www.recoveryfix.com/sqldatabaserecovery.html or download this software: http://www.recoveryfix.com/download-sql-recovery.html

May 12, 2014 | Microsoft Database Software A5K-02817 SQL...

4 Answers

How to Repair Corrupted MS SQL Database (MDF) File?


To choose a reliable and 100% safe and secure, a Microsoft SQL server database recovery program guarantee the zero loss of quality. You can see this page: http://www.en.repairsqlserver.net
See demo: http://www.youtube.com/watch?v=Q0aW1vT5nxA

May 12, 2014 | Microsoft Database Software A5K-02817 SQL...

14 Answers

How can I repair a corrupted MDF files and SQL server?


Similar question has been answered here: http://www.fixya.com/support/t24364927-sql_repair_recovery_process_very

Before asking any question in the forum, first you need to search your problem.

May 12, 2014 | Microsoft Database Software A5K-02817 SQL...

1 Answer

How to move one mysql database to another machine


After logging into MySQL via command prompt, use the below commands.
Backup :
databasename > dumpfile.sql
Restore :
source dumpfile.sql

If you have an IDE like HeidiSQL or SQL Yog, they can make tasks easier through visual interfaces.

Mar 12, 2013 | Compilers & Programming Tools

1 Answer

Database talks to code but code won't talk to database


Make sure you are connecting to the database,then just before you call your sql to insert use an echo statement to display the sql and check it for syntax:-
$sql = 'insert into table1 values('.$no.','.$no.',"block","'.$value3.'", "'.$value4.'")';
echo "SQL ==>" STARTOFSQL<br>".$sql." ENDOFSQL<br>";

Jan 18, 2009 | The PHP Group PHP

1 Answer

Unable to create database from within VWD 2005 Express


try to complete uninstall .net framework and install it again or get the latest copy of .net framework to install 3.5 latest version already available for download

Dec 01, 2008 | Compilers & Programming Tools

2 Answers

PHP Error


This error means that the program doesn't understand the code you wrote.

If you are lucky the error points to the file and the line number where PHP got confused. Sometimes PHP points directly at the error, but other times PHP is confused as a result of an earlier error in the script.

Welcome to the great world of PHP.

Jul 27, 2008 | The PHP Group PHP

4 Answers

QUEST SQL Navigator 3.2 with Oracle 10g Fails


I followed the advice given above and copied the ORACLE_HOME/bin/ociw32.dll to ora73.dll in the same directory. copy ociw32.dll ora73.dll
And the software worked immediately.

Dec 21, 2006 | Quest Software SQL Navigator Professional...

Not finding what you are looking for?
Compilers & Programming Tools Logo

Related Topics:

2,480 people viewed this question

Ask a Question

Usually answered in minutes!

Top Gupta Compilers & Programming Tools Experts

Robin Hill
Robin Hill

Level 3 Expert

1251 Answers

Fred Block
Fred Block

Level 2 Expert

289 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18304 Answers

Are you a Gupta Compiler and Programming Tool Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...