| Using lexical parameters to create hints? [message #90163] |
Mon, 22 November 2004 09:05  |
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!!
Thanks,
Barry
|
|
|
|
| Re: Using lexical parameters to create hints? [message #90164 is a reply to message #90163] |
Mon, 22 November 2004 19:26  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
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.
HTH
Regards
Himanshu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
