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

Answers were Sorted based on User's Feedback



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    6 Yes 3 No

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

Answer / guest

Make sure you're not forgetting to call oci_execute function
before fetching your results (eg. queries inside cycles, etc.)

Is This Answer Correct ?    2 Yes 7 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16040: standby destination archive log file is locked

1 Answers  


PLS-00950: In this version, PL/SQL tables can not be used in this SQL statement.

1 Answers  


ORA-16094: database shutdown during archival operation

1 Answers  


ORA-01973: Missing change number

1 Answers  


ORA-06744: TLI Driver: listener cannot bind

1 Answers  






TNS-12538: TNS:no such protocol adapter

1 Answers  


ORA-16813: apply service not running on the apply instance string recorded by the broker

1 Answers  


RMAN-06542: file string is excluded from whole database backup

1 Answers  


ORA-30150: Invalid argument passed to OCIFile function

1 Answers  


ORA-09871: TASDEF_NAME: translation error while expanding ?/dbs/tasdef@.dbf.

1 Answers  


ORA-14264: table is not partitioned by Composite Range method

1 Answers  


DRG-52208: the specified attribute already exist: string

1 Answers  


Categories