Help - Forms 3.0 bind variables
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
---------------------------------------------------------------------------