RE: Memory Fault erron SQL-SPOOL command

From: Reynaldo Horbino <horbino_at_energy.com.ph>
Date: Mon, 1 Nov 1999 17:01:09 +0800
Message-ID: <newscache$zggikf$nkj$1@news.mozcom.com>

I'm in need of advice.

Recently, after reinstalling ORACLE 7.3.4 on AIX (RS6000) platform, I noticed that some of our SQL programs (containing spool <dir>/<file> , followed by SELECT statement , then spool off ) I tested encounter problems and terminate abnormally. The error message is: <progname> <no>: <number> Memory Fault (coredump).

What is memory fault error ? As a workaround, I edited the SPOOL <dir>/<file> command by shortening the file name. Then it works. This never happen in another server which has the same set-up.

Our server has: AIX 4.2 Operating System; ORACLE 7.3.4 RDBMS.

Rey Received on Mon Nov 01 1999 - 03:01:09 CST