Re: Dynamic Sql in Forms 4.5
Date: 1996/06/25
Message-ID: <4qo9e9$imt_at_news.dknet.dk>#1/1
lokams_at_aa.wl.com (Sreedhar V Lokam) 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
Hi !
You could also use the dbms_sql package (on the server) - this works OK.
Jacob (jcd_at_ramboll.dk) Received on Tue Jun 25 1996 - 00:00:00 CEST