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

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_at_quest.com]=20 Sent: Friday, November 19, 2004 2:29 PM
To: Post, Ethan
Cc: oracle-l_at_freelists.org
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

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