RE: Get Package, Re-write, Re-compile...

From: "Post, Ethan" <Ethan.Post@xxxxxx>
To: "Daniel Wittry" <daniel.wittry@xxxxxxxxx>
Date: Fri, 19 Nov 2004 14:36:45 -0600

Yes thanks, I do that kind of thing also but ideally I need something a
bit more portable.  I manage a lot of databases and I want to easily
install this functionality without having to configure shells and
queues.  Most of this will occur from a web page so it will use a shell
anyway which works fine, but I really want to keep it all in PLSQL if
possible.

-----Original Message-----
From: Daniel Wittry [mailto:daniel.wittry@xxxxxxxxx]=20
Sent: Friday, November 19, 2004 2:29 PM
To: Post, Ethan
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Get Package, Re-write, Re-compile...

My thought would be to spool to utl_file_dir.  Then have a cron job wake
up hourly looking for files to process, run sqlplus @filename from the
shell. Rename the file when done processing.  That would avoid pl/sql
file sizes.  I've done stuff like this before.

__Dan

--
//www.freelists.org/webpage/oracle-l

RE: Get Package, Re-write, Re-compile...

Other related posts: