Hi guys
Looking for a bit of help.
We've a reasonably complex LOV that uses a couple of database package functions in the record group query, it has about 5 block item references in it, some in a couple of places in the query.
When we run the query, replacing the block items with values in SQL it takes under half a second to run, and we're happy with it.
From the form, it's taking 20 minutes.
The reason for this is the block item references, ie bind variables.
Other than dynamically populating the record group with a SQL statement with literals in it each time, I really don't know what we can do.
Just wondered if there were any techniques anyone could suggest ?
I can put the query here if needs be, but due to the sub second running of it in SQL we're quite happy it's ok.
Anyone ?
Thanks a lot
S