Re: ORA-24374

On Apr 15, 4:26 am, ranm..._at_gmail.com wrote:
> Hay gurus,
>
> When a some plsql statements (DML) statements executing in a
> application, I get this oracle error ORA-24374. Can any one help me
> out on this....
>
> not much help in the web on this error :-(
>
> I found out a small description which doesnt make much sence to me....
> can please anyone can explain this reson to me please....
>
> 24374, 00000, "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.
>
> Actually this was just a call to a plsql procedure from a client. And
> it is not possible to recreate the error in any environment. I my self
> was not able to recreate this error but one of my clients get this
> error when they try in there production environment. What i want to
> know exactly is that what this oracle error regarding and what could
> be the possible resons to get this error. Perhaps you ppl have an idea
> what this Oracle error means. I have never seen it before and the
> explanation in the Oracle documentation didn't help me to understand.
>
> Thanks.....

If you are executing the same calls from the same program in multiple different environments and you cannot re-create the error ( if I understand you correctly ) then it sounds potentially like an oracle bug.

It doesn't sound like you have a lot of choice except to work through oracle support and open up a service request etc.

If you have metalink access ( thru a valid oracle support service contract ) then you can also do some researching yourself as it is often more effective to proceed in that direction or at least supplement the efforts that oracle support will make on your behalf. Received on Sun Apr 15 2007 - 12:03:28 CDT