How to create spool in PL/SQL

wwwdavy · #1 (**permalink**) 07-21-03, 01:56

I want to create many different spools in PL/SQL programs, therefore i can't use 'spool' command for create a single in .sql file.

Can any one help me? Thx alot...Urgent!

andrewst · #2 (**permalink**) 07-21-03, 05:42

Quote:

Originally posted by wwwdavy
I want to create many different spools in PL/SQL programs, therefore i can't use 'spool' command for create a single in .sql file.

Can any one help me? Thx alot...Urgent!

Perhaps the UTL_FILE package is what you need? This allows PL/SQL to open, read/write and close files on the server.