Page History

...

The actual data of (A+1)-th column has the size of B, but the length of the host variable has the size of C. so it occurs when the data value exceeds the length of the variable. Therefore, the length of the variable must be set larger than the length of the data. Time From time to time, even if the memory of the host variable is broken due to a program error. Therefore, it is recommended to check whether the host variable's memset or memory is broken. Or, in the case of a threaded program, it can also occur when concurrency control is not properly controlled with a single connection for multiple SQL statements.

...

Code Block
EXEC SQL ALTER SESSION SET STACK SIZE = 4096;

Value overflow or Numeric value out of range (SQLCODE=-135184 or -659472 or -331890)

This is the case when the data value used in the host variable is an input that is larger than the expression range of the column defined in the actual DB.

Check the data value and change the column if necessary.

Conversion not applicable (SQLCODE=-135180 or -659468)

This is the case when conversion between the data type of the column used in ALTIBASe or the type of host variable is not supported.

Code Block

Table T1 (c1 char(10));  
 
Insert into t1 values ('A') ;
  
 
(O) update t1 set c1 = case2(C1 = 1, 0, 1) ;
 
(X) update t1 set c1 =  decode (C1=1, 0, 1); // Boolean type is not allowed in the parameter of decode.

Additionally, an error may occur when a host variable having a data type that cannot be converted is used in CLOB/BLOB handling

Invalid length of the data type (SQLCODE=-135181 or -659469)

This is the case when data larger than the length that can be stored in the DB column is input.

Code Block
Table T1 (c1 char(10)); (X) Insert into t1 values ('AAAAAAAAAAAAAAAAAAAAAAAAA');

Invalid character value for cast specification (SQLCODE=-331893)

This is the case when a string is contained in a numeric host variable and processed.

Declare a host variable suitable for the column type.

Invalid cursor state. (SQLCODE=-331822) or Function sequence error (SQLCODE= -331796)

This is the case when the order to be followed to use the cursor is not performed properly. Or, this error also occurs when a cursor that has already read all data or a cursor that has been closed and calls to fetch again.

The cursor must be opened for fetch (SQLCODE=-1) or The cursor does not exist (SQLCODE=-589857)

To use a cursor normally, it must be processed with the order of PREPARE -> DECLARE -> OPEN -> FETCH -> CLOSE. This error occurs when an attempt is made to FETCH a cursor that is not normally DECLARE/OPEN.

Not enough insert values (SQLCODE=-200787)

This error occurs when the number of columns specified in the INSERT statement and the number of host variables do does not match.

The tablespace does not have enough free space (SQLCODE=-69685 or -69923)

This is the case when there is no space due to the use of all the tablespace capacity during the transaction.

In this case, in the case of the disk tablespace, space must be secured by adding a data file, and in the case of a memory tablespace, available space must be secured by deleting or compacting unnecessary data.

Input literal is not long enough for date format. (SQLCODE=-135218)

This is the case when the string entered into the date function is too short.

Check if there are no errors in the entered data.

Code Block
select TO_DATE('10123', 'yyyymmdd') from DUAL

Literals in the input do not match format string. (SQLCODE=-135224)

This is the case when the date string entered in the data function and the date format do not match.

Code Block
select TO_DATE ('2010123', ' yyyy-mmdd') from DUAL // Error in the yyyy-mm format

The transaction is already active. (SQLCODE=-266311 or -266312)

Commit-mode can be adjusted for each session. In this process, this occurs when a transaction that has not been committed/rolled back exists and changes to Auto-Commit. Therefore, if an error occurs in the process of changing the properties of a session, first check whether a previously occurred transaction exists.

Or, change the session properties after executing Commit/Rollback. Occasionally, in the case of implementing and using a thread program and a connection pool, it may occur when user management for the connection object (ie, when AutoCommit/NonAutoCommit is used in combination) is careless.

The row already exists in a unique index. (SQLCODE=-69720)

This is the case when the value accessed or changed in the INSERT or UPDATE statement already exists in the primary - key or unique index. In this case, check whether the corresponding data value already exists with an inquiry.

Unable to insert (or update) NULL into NOT NULL column. (SQLCODE=- 200790)

This is the case when the column is NOT NULL among the data values entered in the INSERT or UPDATE statement, and a NULL value is attempted to be inserted. Tract data values to prevent NULL data from occurring, or change the NOT NULL Constraints of the column properly.

Indicator variable required but not supplied. (SQLCODE=-331841 or -594101 or 594103)

This case is when the value contained in the host variable from the DB is NULL. This error is returned as SQL_SUCCESS_WITH_INFO. That is, it is an error that recognizes that the passed part is NULL. (There is no guarantee that the actual variable will contain any value.)

To solve this error, it can be solved by performing NVL processing on the column or using a separate int type indicator variable for host variables. Alternatively, the -unsafe_null option can be used among the apre options.

...

Versions Compared

Old Version 5

New Version Current

Key