OraFAQ Forum: SQL & PL/SQL » procedure question

Home » SQL & PL/SQL » SQL & PL/SQL » procedure question

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

procedure question [message #37346]

Fri, 01 February 2002 07:03

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

Report message to a moderator

Re: procedure question [message #37353 is a reply to message #37346]

Fri, 01 February 2002 10:57

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,

Report message to a moderator

Previous Topic:	Difficulty Framing a Query
Next Topic:	please help: pass string into sp

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

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