Saturday 21 April 2012

ORA-24377: invalid OCI function code

ORA-24377: invalid OCI function code

Cause: An invalid function code was used to register or get user callback

Action: Use a valid OCI function code.

ORA-24376: cannot register or get user callback for non-environment handle

ORA-24376: cannot register or get user callback for non-environment handle

Cause: A user callback registration or get was attempted on a handle which is not an environment handle.

Action: Pass the environment handle to register or get user callback.

ORA-24375: Cannot use V6 syntax when talking to a V8 server

ORA-24375: Cannot use V6 syntax when talking to a V8 server

Cause: V6 syntax is no longer supported in V8 server.

Action: Change syntax to V7 syntax or higher.

ORA-24374: define not done before fetch or execute and fetch

ORA-24374: define not done before fetch or execute and fetch

Cause: The application did not define output variables for data being fetched before issuing a fetch call or invoking a fetch by specifying a non-zero row count in an execute call.

Action: Issue OCI define calls for the columns to be fetched.

ORA-24373: invalid length specified for statement

ORA-24373: invalid length specified for statement

Cause: The length specified for the statement is either 0 or too large.

Action: Specify a valid length for the statement.

ORA-24372: invalid object for describe

ORA-24372: invalid object for describe

Cause: The object to be described is not valid. It either has compilation or authorization errors.

Action: The object to be described must be valid.

ORA-24371: data would not fit in current prefetch buffer

ORA-24371: data would not fit in current prefetch buffer

Cause: An internal OCI error has occurred.

Action: Please contact Oracle customer support.

ORA-24370: illegal piecewise operation attempted

ORA-24370: illegal piecewise operation attempted

Cause: Data of a certain datatype that does not support piecewise operation is being sent or fetched in pieces.

Action: Always set the piece value to OCI_ONE_PIECE for datatypes that does not support piecewise operation.

ORA-24369: required callbacks not registered for one or more bind handles

ORA-24369: required callbacks not registered for one or more bind handles

Cause: No callbacks have been registered for one or more of the bind handles which are part of the RETURNING clause.

Action: The bind handles which are to receive data in a DML statememt with a RETURNING clause must have their mode set as DATA_AT_EXEC and callback functions must be registered for these bind handles using OCIBindDynamic.

ORA-24368: OCI mutex counter non-zero when freeing a handle

ORA-24368: OCI mutex counter non-zero when freeing a handle

Cause: This is an internal OCI error.

Action: Contact customer support.

ORA-24367: user handle has not been set in service handle

ORA-24367: user handle has not been set in service handle

Cause: This occurs during authentication of a migratable user. the service handle has not been set with non-migratable user handle.

Action: Service handle must be set with non-migratable user handle when it is used to authenticate a migratable user.

ORA-24366: migratable user handle is set in service handle

ORA-24366: migratable user handle is set in service handle

Cause: This occurs during user authentication, a migratable user handle has been set in the service handle.

Action: Service handle must not be set with migratable user handle when it is used to authenticate another user.

ORA-24365: error in character conversion

ORA-24365: error in character conversion

Cause: This usually occurs during conversion of a multibyte character data when the source data is abnormally terminated in the middle of a multibyte character.

Action: Make sure that all multibyte character data is properly terminated.

ORA-24364: internal error while padding blanks

ORA-24364: internal error while padding blanks

Cause: An internal error has occurred while attempting to blank pad string data. This error should not occur normally.

Action: Contact customer support.

ORA-24363: measurements in characters illegal here

ORA-24363: measurements in characters illegal here

Cause: Measurements in characters instead of bytes are illegal if either the server s or client s character set is varying width.

Action: If either the client s or server s character set is varying width then do not use the OCI_ATTR_CHAR_COUNT attribute for the bind handle. Use OCI_ ATTR_MAXDATA_SIZE instead.

ORA-24362: improper use of the character count flag

ORA-24362: improper use of the character count flag

Cause: When the character count flag is set, then the maximum size of the buffer in the server should be specified as a non-zero value.

Action: Please use a non-zero value for the mamimum size of the buffer in the server.

ORA-24361: basic bind call not invoked before invoking advanced bind call

ORA-24361: basic bind call not invoked before invoking advanced bind call

Cause: One of the basic bind calls was not invoked on this bind handle before performing an advanced bind call.

Action: Please invoke the advanced bind call on this bind handle only after performing a basic bind call.

ORA-24360: Type Descriptor Object not specified for Object Bind or Define

ORA-24360: Type Descriptor Object not specified for Object Bind or Define

Cause: Type Descriptor Object is a mandatory parameter for Object Types Binds and Defines.

Action: Please invoke the OCIBindObject() or OCIDefineObject() call with a valid Type Descriptor Object.

ORA-24359: OCIDefineObject not invoked for a Object type or Reference

ORA-24359: OCIDefineObject not invoked for a Object type or Reference

Cause: OCIDefineObject was not invoked resulting in an incomplete bind specification for a Object Type or Reference.

Action: Please invoke the OCIDefineObject call for all Object Types and References.

ORA-24358: OCIBindObject not invoked for a Object type or Reference

ORA-24358: OCIBindObject not invoked for a Object type or Reference

Cause: OCIBindObject was not invoked resulting in an incomplete bind specification for a Object Type or Reference.

Action: Please invoke the OCIBindObject call for all Object Types and References.

ORA-24357: internal error while converting from to OCIDate.

ORA-24357: internal error while converting from to OCIDate.

Cause: An internal error was encountered during conversion to OCIDate type.

Action: Contact customer support.

ORA-24356: internal error while converting from to COBOL display type.

ORA-24356: internal error while converting from to COBOL display type.

Cause: An internal error was encountered during conversion to COBOL display type.

Action: Contact customer support.

ORA-24355: attempt to store a negative number in an Unsigned Display type.

ORA-24355: attempt to store a negative number in an Unsigned Display type.

Cause: An attempt was made to convert a negative number into an unsigned display type.

Action: Please check the number in the database or change the defined datatype.

ORA-24354: number fetched too large to fit in COBOL display type buffer.

ORA-24354: number fetched too large to fit in COBOL display type buffer.

Cause: The number fetched was beyond the range that can be displayed.

Action: Please check the number in the database.

ORA-24353: user buffer too small to accommodate COBOL display type

ORA-24353: user buffer too small to accommodate COBOL display type

Cause: User supplied buffer for a COBOL display type was too small to accommodate fetched number.

Action: Increase the allocation for COBOL display type buffer.

ORA-24352: invalid COBOL display type passed into OCI call

ORA-24352: invalid COBOL display type passed into OCI call

Cause: A bad COBOL display type was passed into one of the OCI calls.

Action: Check your COBOL display type bind values and correct them.

ORA-24351: invalid date passed into OCI call

ORA-24351: invalid date passed into OCI call

Cause: A bad date was passed into one of the OCI calls.

Action: Check your date bind values and correct them.

ORA-24350: OCI call not allowed

ORA-24350: OCI call not allowed

Cause: OCI used is not permitted from external procedures.

Action: Refer to user manual for usage restrictions.

ORA-24348: Update or Delete without Where

ORA-24348: Update or Delete without Where

Cause: An update or delete was executed without where clause

Action: An OCI_SUCCESS_WITH_INFO is returned.

ORA-24347: Warning of a NULL column in an aggregate function

ORA-24347: Warning of a NULL column in an aggregate function

Cause: A null column was processed by an aggregate function

Action: An OCI_SUCCESS_WITH_INFO is returned.

ORA-24346: cannot execute without binding variables

ORA-24346: cannot execute without binding variables

Cause: None of the bind variables in the SQL statement are bound.

Action: Please bind all the variables before the execute is done.

ORA-24345: A Truncation or null fetch error occurred

ORA-24345: A Truncation or null fetch error occurred

Cause: A truncation or a null fetch error

Action: Please ensure that the buffer size is long enough to store the returned data.

ORA-24344: success with compilation error

ORA-24344: success with compilation error

Cause: A sql or plsql compilation error occurred.

Action: Return OCI_SUCCESS_WITH_INFO along with the error code

ORA-24343: user defined callback error

ORA-24343: user defined callback error

Cause: The only valid return value for a user defined callback function is OCI_ CONTINUE or OCI_ROWCBK_DONE. Any other value will cause this error.

Action: Please insure that OCI_CONTINUE or OCI_ROWCBK_DONE is returned from the user defined callback function.

ORA-24342: unable to destroy a mutex

ORA-24342: unable to destroy a mutex

Cause: An attempt to destroy a mutex failed.

Action: none

ORA-24341: bad mode specified

ORA-24341: bad mode specified

Cause: OCI_ENV_NO_MUTEX mode was specified for a non-threaded client.

Action: OCI_ENV_NO_MUTEX may be specified when OCI_THREADED had been specified at process initialization.

ORA-24340: cannot support more than 255 columns

ORA-24340: cannot support more than 255 columns

Cause: The number of columns exceeds maximum supported by the server.

Action: Limit your operation to 255 columns.

ORA-24339: cannot set server group name after connecting to server

ORA-24339: cannot set server group name after connecting to server

Cause: An attempt was made to set the server group in a server handle after connecting to the server. However, once the connection is established to a server, the server group name cannot be set anymore.

Action: Attach to the server after setting the server group name in the server handle.

ORA-24338: statement handle not executed

ORA-24338: statement handle not executed

Cause: A fetch or describe was attempted before executing a statement handle.

Action: Execute a statement and then fetch or describe the data.

ORA-24337: statement handle not prepared

ORA-24337: statement handle not prepared

Cause: A statement cannot be executed before making preparing a request.

Action: Prepare a statement before attempting to execute it.

ORA-24336: invalid result set descriptor

ORA-24336: invalid result set descriptor

Cause: The result set descriptor should have valid data fetched into it before it can be converted to a statement handle

Action: Fetch valid data into the descriptor before attempting to convert it into a statement handle

ORA-24335: cannot support more than 1000 columns

ORA-24335: cannot support more than 1000 columns

Cause: The number of columns exceeds the maximum number supported.

Action: none

ORA-24334: no descriptor for this position

ORA-24334: no descriptor for this position

Cause: The application is trying to get a descriptor from a handle for an illegal position.

Action: Check the position number.

ORA-24333: zero iteration count

ORA-24333: zero iteration count

Cause: An iteration count of zero was specified for the statement

Action: Specify the number of times this statement must be executed

ORA-24332: invalid object type

ORA-24332: invalid object type

Cause: An invalid object type is requested for the describe call.

Action: Specify a valid object type to the describe call.

ORA-24331: user buffer too small

ORA-24331: user buffer too small

Cause: The user buffer to contain the output data is too small.

Action: Specify a bigger buffer.

ORA-24330: internal OCI error

ORA-24330: internal OCI error

Cause: An internal OCI error has occurred.

Action: Please contact Oracle customer support.

ORA-24329: invalid character set identifier

ORA-24329: invalid character set identifier

Cause: The character set identifier specifed is invalid

Action: Specify a valid character set identifier in the OCI call.

ORA-24328: illegal attribute value

ORA-24328: illegal attribute value

Cause: The attribute value passed in is illegal.

Action: Consult the users manual and specify a legal attribute value for the handle.

ORA-24327: need explicit attach before authenticating a user

ORA-24327: need explicit attach before authenticating a user

Cause: A server context must be initialized before creating a session.

Action: Create and initialize a server handle.

ORA-24326: handle passed in is already initialized

ORA-24326: handle passed in is already initialized

Cause: An attempt was made to pass an initialized handle.

Action: Verify that the parameter passed in to retrieve a handle does not already point to a handle.

ORA-24325: this OCI operation is not currently allowed

ORA-24325: this OCI operation is not currently allowed

Cause: An attempt was made to use a context handle outside its scope.

Action: Verify that the context handle is set to a service context handle that has been converted to a logon data area for other OCI calls. The logon data area must be converted back to a service context before it can be used.

ORA-24324: service handle not initialized

ORA-24324: service handle not initialized

Cause: An attempt was made to use an improper service context handle.

Action: Verify that the service context handle has all the parameters initialized prior to this call.

ORA-24323: value not allowed

ORA-24323: value not allowed

Cause: A null value or a bogus value was passed in for a mandatory parameter.

Action: Verify that all mandatory parameters are properly initialized.

ORA-24322: unable to delete an initialized mutex

ORA-24322: unable to delete an initialized mutex

Cause: An attempt to delete an initialized mutex failed.

Action: Contact customer support.

ORA-24321: inconsistent parameters passed

ORA-24321: inconsistent parameters passed

Cause: One of the three memory function pointers is null or non-null.

Action: Verify that either all the memory functions are null or non-null.

ORA-24320: unable to initialize a mutex

ORA-24320: unable to initialize a mutex

Cause: An attempt to initialize a mutex failed.

Action: Contact customer support.

ORA-24319: unable to allocate memory

ORA-24319: unable to allocate memory

Cause: Process was unable to allocate memory to store diagnostics.

Action: Terminate other processes in order to reclaim needed memory.

ORA-24318: call not allowed for scalar data types

ORA-24318: call not allowed for scalar data types

Cause: This call is valid only for object types.

Action: Verify that the data-type for this variable is an object type

ORA-24317: define handle used in a different position

ORA-24317: define handle used in a different position

Cause: A define was done with an existing handle on a different position.

Action: Specify the same position as before on a re-define.