Home » SQL & PL/SQL » SQL & PL/SQL » procedure question
procedure question [message #37346] Fri, 01 February 2002 07:03 Go to next message
Lance Pris
Messages: 40
Registered: January 2002
Currently I run a stored procedure and manually take the results and save them to a xls file. I have few questions:

1. Is it possible to automatic this?
2. Is it possible to save is as an access file?
3. If it possible to do either of the above. Does anyone have examples that I could use?

Thank you in advance
Re: procedure question [message #37353 is a reply to message #37346] Fri, 01 February 2002 10:57 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
If your proc is using dbms_output, you can just call it from an SQL script called through sqlplus using an O/S script in an O/S job scheduler (cron in unix).
If you use utl_file, you can just run your proc as a database job usung dbms_job.
See the following URL on creating Excel files.
Previous Topic: Difficulty Framing a Query
Next Topic: please help: pass string into sp
Goto Forum:

Current Time: Mon Sep 25 19:27:43 CDT 2023