Re: Pb using UTL

From: <Dawn.Hoffmann_at_reedtech.com>
Date: Tue, 22 Feb 2000 17:19:22 GMT
Message-ID: <88ugej$7co$1@nnrp1.deja.com>

I imagine you already got a reply, but if you didn't I found one in some of the older posts. Here is the answer to the 1023 problem:

In 8.0.5 and up, the spec of fopen is now:

FUNCTION FOPEN RETURNS RECORD

Argument Name                  Type                    In/Out Default? -
----------------------------- ----------------------- ------ --------
ID                          BINARY_INTEGER          OUT
LOCATION                      VARCHAR2                IN
FILENAME                      VARCHAR2                IN
OPEN_MODE                      VARCHAR2                IN
MAX_LINESIZE                  BINARY_INTEGER          IN

set max_linesize to some number upto 32k to make the linesize be that (instead of ~1000 bytes)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Feb 22 2000 - 11:19:22 CST

Re: Pb using UTL_FILE