Re: PLSQL - Escaping to host?

fern_at_aa.net (Fernando Luna) wrote:

>If, judging from the example you provided, all you want to do is
>retrieve records and spool them out to a file, you wouldn't need
>PL/SQL to do that. I'm sure that your problem is a little more
>involved, though. Perhaps you could do it from SQL*Forms, where the
>call to "Host" is valid?

Hi Fernando!

What I needed it for was a PL/SQL packaged procedure, which would sit around waiting for a database "on insert" trigger to fire. So whenever a row was inserted into the table, the pacakge would be fired, process the information in the row, and write a report out to a list of printers.

The row is inserted as part of an interface from an automated laboratory instrument data collector package from a third party, which runs on a seperate box altogether, so I can't really use forms for this application! I've got round the problem now by using DBMS pipes as suggested - shame it has to be so long-winded though :-)

	thanks,
		Simon :-)

--
Simon Holt --  System Designer/DBA
** My opinions are not nescessarily those of my employers **
Britannia Zinc Ltd.  (+44) 0117 982 3646