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

From: Daniel Wittry <daniel.wittry_at_quest.com>
Date: Fri, 19 Nov 2004 12:28:47 -0800
Message-ID: <B5C5F99D765BB744B54FFDF35F6026210D4B0151@irvmbxw02>

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

Received on Fri Nov 19 2004 - 14:39:54 CST

This message: [ Message body ]
Next message: Post, Ethan: "RE: Archived logs maintanance"
Previous message: Guang Mei: "RE: Archived logs maintanance"
Maybe in reply to: Post, Ethan: "Get Package, Re-write, Re-compile..."
Next in thread: Post, Ethan: "RE: Get Package, Re-write, Re-compile..."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US