?
Solved

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

Posted on 2007-09-28
5
Medium Priority
?
2,262 Views
Last Modified: 2013-12-19
We are correcting several Actuate reports for the ICM Application.

For one of the reports we have a select query imbeded in the Actuate report.

We run this query against the oracle 9i database.

This query works perfectly fine from Toad or Actuate Development Tool (erdPro ). But once we port the report executable on the Actuate server and try to run the report, we get following error message :

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

Could you please help us identify the problem?
0
Comment
Question by:ashu2769
4 Comments
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 19979268

Did you check out the error message?

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.
0
 
LVL 18

Expert Comment

by:Jinesh Kamdar
ID: 19983592
0
 

Author Comment

by:ashu2769
ID: 20000716
Hi,
I am really not clear how can I fix this. Should I try writing SQL code in some other way?

Thanks and regards,
-Ashu
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 22198069
PAQed with no points refunded (of 500)

Computer101
EE Admin
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses
Course of the Month14 days, 15 hours left to enroll

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question