LONG -> disk?! PL/SQL (Or8/NT)
From: James <jgp_at_yallara.cs.rmit.edu.au>
Date: 22 Apr 1998 11:34:35 GMT
Message-ID: <6hkkkb$tb$1_at_goanna.cs.rmit.edu.au>
Hi all,
Date: 22 Apr 1998 11:34:35 GMT
Message-ID: <6hkkkb$tb$1_at_goanna.cs.rmit.edu.au>
Hi all,
Simple question:
How do I get a variable of type LONG onto disk in a flat file?!
Complex question:
UTL_FILE.PUT(..) only deals with VARCHAR2 (and only the first 1023
bytes of that!)
The Oracle PL/SQL manual mentions a DEFINE_COLUMN_LONG procedure
in the dymanic PL/SQL section, but that would require re-writing
most of the queries to be dynamic. It iterates through a LONG, putting
chunks into a VARCHAR2, but requires a CURSOR and CURSOR offset.
Wouldn't the world be a happier place with PUT_LONG(FILE_TYPE,LONG)?!
Comments most welcome!
james Received on Wed Apr 22 1998 - 13:34:35 CEST