PL/SQL problem: DMBS_SQL

From: asdf <adsf_at_asdf.sdfg>
Date: Sat, 25 Apr 1998 14:02:12 +1000
Message-ID: <35416044.A96C9027@asdf.sdfg>

Hi all,

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

 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);

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

     cursor."

The dynamic cursors have been working fine for all other attribute types and
I know the LONG is much longer that 1023 (about 5k, actually). The v_num_read = 1023 after the evaluation. If I un-comment the line above the put(),
it writes the 'Nulled test' string ok to the file. As shown, I get:

  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

Very strange indeed. Received on Fri Apr 24 1998 - 23:02:12 CDT