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

Question Posted / guest

2 Answers
13517 Views
I also Faced
E-Mail Answers

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