Re: Host command execution

"Christopher J Gerrior Sr." <cgerrior_at_pop.erols.com> wrote:

>You can not use the HOST command in PL/SQL, but there is another
>option, DBMS_PIPE.SEND_MESSAGE, which I'm not sure if it
>will work in your situtation. If you could expand if this
>is running in C/S environment ect... I might be able to provide
>you with more information.

Hi Chris,

        I'm designing a system using designer 2000, which will be client/server, i.e Forms 4.5 on the client, which may make use of pacakges on the Server side.

	Client: Windows 3.11, Forms 4.5
	Server: HP-UX 10.01 GBR, PL/SQL 2.1.4

The package I want to define should sit on the Server, and invoke server host commands (i.e HP-UX commands to print, build a file, etc)

However, the package wouldn't be invoked from a client application - It will run as a result of an AFTER INSERT database trigger firing: The idea being that when information is inserted into the table, the package is invoked by the trigger, does some processing of the data to build up a print file, and then sends the file to a list of printers which is held in another table (see previous post).

Hope that makes sense - Any information you can give me would be much appreciated!

			thanks,
				Simon
 

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