Re: Accessing variable table names in Forms 4.5

Mark

Check out the usage notes for the FORMS_DDL function in the manual or online help regarding committing pending changes.

Also any dynamic statement will run under the security domain of the user of the form, this may not be appropriate. If you use DBMS_SQL in a stored procedure the the code will run under the security domain of the owner of that stored procedure.

Regards

Nick

Mark Rittman wrote:
>
> >
> >Alternately you can use the FORMS_DDL function but be aware that there
> >are limitations with this.
> >
> >DBMS_SQL is extremely useful & powerful and worth persevering with.
> >
> >Regards
> >
> >Nick
>
> Thanks Nick,
>
> What are the limitations with FORMS_DDL? I used this as my eventual
> workaround, but found that I had to issue a 'commit' statement after the
> FORMS_DDL statement, or the program hung (this was from within Forms 4.5 on
> NT4).
>
> Many thanks
>
> Mark
Received on Mon Dec 07 1998 - 12:32:27 CET