Re: LONG -> disk?! PL/SQL (Or8/NT)

From: James Preston <jgp_at_cs.rmit.edu.au>
Date: Sat, 25 Apr 1998 14:23:10 +1000
Message-ID: <3541652E.B899D05F_at_cs.rmit.edu.au>

And in further news:

After the stoney silence from the initial post, I have been trying to get DEFINE_COLUMN_LONG working and have been having trouble:

(CROSS POST) I'm having trouble with the following code snippet for PL/SQL on Oracle8 for NT:

Given 'select attrib_value from a_table' where attrib_value is a LONG,

 dbms_sql.column_value_long(v_cursor_id, 1, 1023, 1, v_chunk_buffer,
v_num_read);
 -- v_chunk_buffer := 'Nulled test');

 utl_file.put(v_f, v_chunk_buffer); -- fails here

ie. "Please put positions 1 trough 1023 into v_chunk_buffer from the 1st column in

     cursor."

Gives:

  ORA-06510: PL/SQL: unhandled user-defined exception
  ORA-06512: at "SYS.UTL_FILE", line 93
  ORA-06512: at "SYS.UTL_FILE", line 175
  ORA-06512: at line 31

Huh? Received on Sat Apr 25 1998 - 06:23:10 CEST