Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Dynamic sql from FORMS 4.5

Re: Dynamic sql from FORMS 4.5

From: <Dan>
Date: 1997/05/16
Message-ID: <5lhk18$iit@drn.zippo.com>#1/1

In article <Pine.SOL.3.91.970516082341.29820A-100000_at_biotec>, Abiy says...
>
>Hi friends,
>
>I would like to make a SELECT statement (dynamically) from FORMS 4.5.
>Is it possible to make a FORMS_DDL('SELECT INTO something ...') ? Or is

Well, the only way to "dynamicly" set a WHERE clause is SET_BLOCK_PROPERTY. Use it to specify the "default" WHERE clause for the block. I've not tried this, but I've heard that it works.

Hope this helps.

Dan Received on Fri May 16 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US