Help - Forms 3.0 bind variables

From: Bryan Bell <bryan_at_b-mc.demon.co.uk>
Date: 1996/02/15
Message-ID: <323077172wnr_at_b-mc.demon.co.uk>#1/1


Hi, this is just a general question about the use of bind variables in Forms 3.0.16.12.9.

We've noticed on our V7.1.4 database that there are a lot of similar SELECT statements in the v$sqlarea table, e.g.

       Select col1, col2, col3, col4 from table where col3 <> 'D' and 
       col3 <> 'C' and (primarykey = number) order by primarykey

The 'table' is a base table for a table maintenance block. Out of all of these statements, only the 'number' is different. I believe that this is due to the user entering a specific value in the primarykey field in ENTER QUERY mode (sorry this is vague but I do not know which program is issueing the statements). The statement looks like a dynamic sql statement that runform creates at runtime for a query block.

Incidentally, the forms were originally developed under V6 and recompiled under V7.

Questions:
1) Are we correct in our assumption of what we can see in the v$sqlarea table, ie bad performance?

2) If (1) = 'yes' then is there a way of changing the block so that it uses a bind variable for each of the 'query allowed' fields that will reduce the amount of statements being seen in the v$sqlarea table.

All answers greatly appreciated.

Thanks
Bryan
.


| Bryan Bell                                 EMail bryan_at_b-mc.demon.co.uk |

---------------------------------------------------------------------------
Received on Thu Feb 15 1996 - 00:00:00 CET

Original text of this message