Re: How to call a script in forms ?

From: Fernando Guijarro <nandoguijarro_at_mx2.redestb.es>
Date: 1997/05/08
Message-ID: <01bc5bf0$d28a7820$LocalHost_at_anubis>#1/1


Erik Oosterling <Erik.Oosterling_at_cmg.nl> escribió en artículo <33709aca.862386_at_193.79.171.11>...
> Hello there,
>
> I try to call a SQL script in a form (4.5) but no result because i
> don't know how to do this. Is there anybody who know s how to do this
> without the use of the HOST command.
>
>
> Thank you !
>
>

You can use the SYS.DBMS_PIPE package and and make a procedure than allow you to send messages ( commands ) to a listener program runing in server. The listener can then send the command to the system. It´s easy. You can find a example in Server Developer's Guide.

-- 
	   ________	  _________
	 /|    ______|	 /|    ______|	NandoGuijarro_at_mx2.redestb.es
	| |    |_____/    	| |    |_____/	Fernando Guijarro
	| |    ___|        	| |    |     ___	Madrid - Spain
	| |    |__/         	| |    |___|    |
	| |__ |             	| |________|
	|/__ /		|/________/
Received on Thu May 08 1997 - 00:00:00 CEST

Original text of this message