Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ORA-6502 on Solaris 9i, but not on Windows 9i

ORA-6502 on Solaris 9i, but not on Windows 9i

From: Cheng-Jih Chen <postmaster_at_cjc.org>
Date: Tue, 06 Aug 2002 16:13:02 -0000
Message-ID: <ukvtceo9kacde0@news.supernews.com>


My developers are getting an ORA-6502 error when attempting to load a file using the utl_file facilities. The error occurs on a Solaris 64-bit 9i installation, but not on a similar Windows installation. The error also occurs if the full file is being loaded; if a small subset of the file is being loaded, there is no error. Strangely, the lines that get loaded in the subset error out when we attempt to load the full file.

There doesn't appear to be any substansive differences in v$parameters between the Solaris and NT installations.

The files in question are simple delimited text files on the order of a few hundred K. We're using utl_file instead of sqlldr because of the processing we have to do on the data as they get loaded.

Can anyone help? Thanks. Received on Tue Aug 06 2002 - 11:13:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US