Home » Developer & Programmer » Forms » how to execute dynamic query what is the syntax
icon7.gif  how to execute dynamic query what is the syntax [message #121117] Thu, 26 May 2005 03:36 Go to next message
saivenkat
Messages: 13
Registered: April 2005
Junior Member
can anyone tell me the syntax to execute dynamic query thro forms.

Report message to a moderator

Re: how to execute dynamic query what is the syntax [message #121126 is a reply to message #121117] Thu, 26 May 2005 04:48 Go to previous messageGo to next message
A Ikramur Rahman
Messages: 81
Registered: May 2004
Member
In ORACLE Forms, you can change your database block query during runtime by setting the DEFAULT_WHERE block property.

Report message to a moderator

Re: how to execute dynamic query what is the syntax [message #121128 is a reply to message #121117] Thu, 26 May 2005 04:58 Go to previous messageGo to next message
dmitry.nikiforov
Messages: 723
Registered: March 2005
Senior Member
If you mean to do in Forms something like
EXECUTE IMMEDIATE <<sql_statement>>, it's not supported
there. Use DBMS_SQL package in Forms.

Rgds.

Report message to a moderator

Re: how to execute dynamic query what is the syntax [message #121429 is a reply to message #121117] Sat, 28 May 2005 17:10 Go to previous message
danosw
Messages: 20
Registered: May 2005
Location: California
Junior Member
Another option is to use a block with 'Query Data Source Type' = 'From clause query'... and in the pre_query trigger of the block use the built-in SET_BLOCK_PROPERTY to set the QUERY_DATA_SOURCE_NAME.

We use this option when we have complicated searching.
You can't update or insert data.

Report message to a moderator

Previous Topic: problem in forms
Next Topic: Sending a mail with an attachment from Oracle forms6i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 10 01:32:33 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.