Home » Developer & Programmer » Reports & Discoverer » Using lexical parameters to create hints?
Using lexical parameters to create hints? [message #90163] Mon, 22 November 2004 09:05 Go to next message
Barry Brierley
Messages: 10
Registered: November 2004
Junior Member
Hello there,

I have quite a big query with three different lexical 'where conditions'. Problem is, it really needs a hint, and the hint would vary depending on what lexical 'where conditions' are being used at the time.

a.) I'd like to do something like this :
select &hint g.segment1 ....

b.) In my afterparameterform trigger do this:
&hint := 'select /*+ INDEX(b XXLTDS_MTL_TRANSACTIONS_IND) */ ';

c.)Resulting in this:
select /*+ INDEX(b XXLTDS_MTL_TRANSACTIONS_IND) */ g.segment1 ....

Problem is, I can't enter a lexical in my select statement. (can't even enter a hint). ora-24323

Any ideas most appreciated!!

Re: Using lexical parameters to create hints? [message #90164 is a reply to message #90163] Mon, 22 November 2004 19:26 Go to previous message
Messages: 457
Registered: December 2001
Senior Member
Make your report without any hints.

Then prepare the complete select statment in your form.

Call the report by passing Data_parameter, in which you can pass the complete Record group of the report i.e. the data of your report will be passed through From.

Note that you can pass data parameter only if you are using RUN_PRODUCT to call the report.

Otion 2:
Make the report based on Ref cursor.

Previous Topic: EXISTS operator performance
Next Topic: order in whihc report trigger works
Goto Forum:

Current Time: Wed Feb 21 13:15:45 CST 2024