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
Member
All,
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
Lance
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.
http://asktom.oracle.com/pls/ask/f?p=4950:8:103554::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:728625409049,
Previous Topic: Difficulty Framing a Query
Next Topic: please help: pass string into sp
Goto Forum:
  


Current Time: Thu Jul 02 11:27:25 CDT 2020