Re: Dynamic Sql in Forms 4.5

arthurk_at_ibm.net wrote:

>I need to present the same data from several tables onto a Forms 4.5 (Win 3.11)
>form. I'd like to write a dynamic SQL statement to manipulate the table name,
>but to date I've been unsuccessful. I tried using the 'dbms_sql' package calls,
>but the PL/SQL compiler complains the package is unknown.
 

>I can't find a reference to dynamic SQL in the documentation, so I'm starting to
>wonder whether this can be done at all.
 

>Thanks in advance!
 

>Kurt Arthur
>Cooperative Technical Services
>arthurk_at_ibm.net

Hi Kurt :
Why Dont you Try Using FORMS_DDL standard package provided in Forms 4.5. This is used to do dynamic SQL. iF any specific questions please repost with specs.

Sreedhar V Lokam
lokams_at_aa.wl.com Received on Mon Jun 24 1996 - 00:00:00 CEST