Re: PL/SQL-script in Forms 2.3

Sqlforms 2.3 does not directly support PL/SQL. If you do not want to pass the userid/password, check if your system supports the OPS$ login ( this would be for multiuser o/s). All you need to do is pass a "/" and it will use the current login ID. In V7, this feature has been somewhat revised.

A PL/SQL script can accept parameters just the same way as reqular SQL*Plus scripts.

b09_at_nikhef.nl (Jeroen Hermans) wrote:

>
>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
Received on Wed Nov 16 1994 - 03:18:55 CET