using util_file

From: Chris Eastwood <c.undieseastwood_at_gu.edu.au>
Date: Mon, 16 Nov 1998 02:24:59 GMT
Message-ID: <72nut6$87p$1_at_kraken.itc.gu.edu.au>

HiYa

I have been trying to use this package, and I have been stumped at an early stage, cna anyone help me with this?

when using the code:

declare  

file_hd UTL_FILE.FILE_TYPE;  

cursor maxed is
select LDG_NAME, ACCNBRI
from glf_ldg_acct_pbal;  

procedure boing(info varchar2) is
begin
  dbms_output.put_line('boing '||info);
end;  

begin
dbms_output.enable(1000000);  

dbms_output.put_line('starting');
[Quoted] file_hd := UTL_FILE.FOPEN('/tmp/', 'bill.dat', 'W');  

/*

for wot in maxed loop
  UTL_FILE.put_line(file_hd, wot.LDG_NAME||'and '||wot.ACCNBRI); end loop;
*/
end;
/

I get

SQL_at_FIN_TEST>@output
starting
declare
*
ERROR at line 1:

ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.UTL_FILE", line 82
ORA-06512: at "SYS.UTL_FILE", line 120
ORA-06512: at line 13

Thanks

See Ya
[Quoted] (when bandwidth gets better ;-)

Chris Eastwood

Photographer, Programmer               email    ua.ude.ug.cti_at_doowtsae.c
Motorcyclist and dingbat               WWW   http://chrise.itc.gu.edu.au

please remove undies for reply

---

Ohhh ... you work all day, slave over a hot stove all night  yet you *still* have time for sadomasochism ... how do you do it?

A little man hurts me.

<ding>

    Oh Mister Mean ... Oh Mister Mean
    15 Minutes with him and you'll be blue and green     Studded belts and leather whips
    Bondage trousers on his hips
    Wack and punish as you dust with Mister Mean   Ohhhh he whips me around the house in minutes ... lets get cracking ... Received on Mon Nov 16 1998 - 03:24:59 CET