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-38469: invalid privilege for an expression set: string

1 Answers  


ORA-23465: flavor already includes column string of "string"."string"

1 Answers  


LFI-00005: Free some memory failed in string.

1 Answers  


RMAN-06175: deleted script: string

1 Answers  


ORA-09877: sstascre: shmget error, unable to get a shared memory segment.

1 Answers  






ORA-13052: unsupported geometric type for geometry string.string

1 Answers  


PLS-00422: no PL/SQL translation for the bindtype given for this bind variable

1 Answers  


IMP-00055: Warning: partition or subpartition "string":"string" not found in export file

1 Answers  


TNS-12552: TNS:operation was interrupted

1 Answers  


ORA-15048: ASM internal files cannot be deleted

1 Answers  


LPX-00216: invalid character ~1u (~2X)

1 Answers  


ORA-25956: join index cannot be created on tables owned by SYS

1 Answers  


Categories