Hi Dba's

I am running an sql and gets an error ORA-22813 . I have 2 versions of oracle 9.2.0.1 and 9.2.0.2 . The sql runs fine on 9.2.0.1 but not in 9.2.0.2. I have got enough memory available . The query returns 150,000 records . Both servers have the same amount of memory available.

Any help

Thanks





------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
The information in this message and any attachments is privileged,confidential and/or exempt from disclosure under applicable law.
If you are not the intended recipient, please do not copy, use or disclose the information to others;also please notify the sender by
replying to this message, and then delete it from your system.E-mail transmission cannot be guaranteed to be secure, error and virus
free. The sender therefore accepts no liability for any errors or omissions in the contents of this message, which arise as a result of
e-mail transmission

Oracle LazyDBA home page