Re: How to add an object to an existing table?

weberm_at_polaris.net (Ubiquitous) wrote in message news:<cnjnvh$l3o$15_at_news.utelfla.com>...
> Galen Boyer <galenboyer_at_hotpop.com> wrote:
> : On Thu, 18 Nov 2004, weberm_at_polaris.net wrote:
> :> DA Morgan <damorgan_at_x.washington.edu> wrote:
>
> :>: A trigger. A trigger can call any package, procedure, or
> :>: function.
> :>
> :> Ah, but how would you trigger the trigger to parse and load the
> :> data file?
> :
> : Use an external table to "parse" the file and a select against
> : that external table to "load" the file and a trigger to kick the
> : whole thing off.
>
> I see, but that's a LOT more work just invoking load_table(file_name).

A whole lot more work in Oracle 8 (look at the OP)! :-O

jg

--
@home.com is bogus.
http://www.floridatoday.com/!NEWSROOM/moneystoryB1031BATTLEBOT.htm