Q:PL/SQL How to create a File ..

Hallo *.*
Please help an Oracle Beginner.
Can someone tell me how to create a file with a PL/SQL script. Spool c:\test.txt will not work ??
Somebody told about utlfile.sql, but do not know how to use it.

It was nice if you can declare what you doing.

Here is what I want to do :
create or replace procedure do_update as iScan number;
iTempax number;
begin

    select count(*)
    into iScan
    from scan
    where to_date(timestamp,'dd.mm.yyyy') = to_date(sysdate,'dd.mm.yyyy');

    select count(*)
    into iTempax
    from Tempax;

    if iScan = iTempax then

            mailax2fibu;
    else

• Create a File with something in end if; end;

I work with Oracle8 on NT4.

bye
Ralf

mailto:Ralf.Bender_at_wolnet.de Received on Sun Jul 05 1998 - 08:58:07 CDT