Re: PL/SQL-script in Forms 2.3

In article <b09-081194124936_at_macaux.nikhef.nl>, b09_at_nikhef.nl (Jeroen Hermans) writes:
>Hello reader,
>
>I am using Sqlforms2.3. I have written an PL/SQL-script which I want to
>execute from Sqlforms.
>I have tried to make the following command in a trigger:
>#HOST 'sqlplus user/passwrd <delete.sql'
>
>There are two problems with it:
>-I must pass on the user_id and his/her password.
>-I want to pass a parameter to the PL-SQL-script.
>
>What do I have to alter to the trigger or should I use another command.
>
>Jeroen

        Hi Jeroen,

	Here's the code I use in my Forms 2.3 triggers. I am passing the
	value from the form called TRACENO. I use only OPS$ accounts, so
	there are no username/passwords to see, but in any case, the 
	NOSCREEN would prevent the user from seeing it.

	E-mail me if you need more info. Good luck!

#HOST 'SQLPLUS -S / _at_TRACE_APPL$:HIST_HPS_XREF "'||:TRACENNO || '" ' NOSCREEN

	^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
	Vicki Sadowski			** all current disclaimers apply **
	sadowsvl_at_a1.spoc2.umc.dupont.com	ORACLE DBA V6.0.33
	DuPont Co.			** Mom to Eric (10/12/89)        **
	Seaford, Delaware		**   and  Rachel (6/20/92)	 **
	^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^