Home » Developer & Programmer » Reports & Discoverer » Is there any way to prevent a query from executing at run time
Is there any way to prevent a query from executing at run time [message #88193] Tue, 30 April 2002 05:53 Go to next message
Smitha
Messages: 17
Registered: June 2001
Junior Member
Hi,
Is there any way to prevent a query from executing at run time.
For Eg: I have two queries Q1 and Q2. I have a user parameter P1. If P1=’N’ then query Q1 should not be executed at all .This is required because in our system when P1 =’N’ the tables in query Q1 do not exist. If it is executed then “Table/View not found “error displays.

One way is to use lexical parameters.
Is there any other easy way?

Any help is appreciated.
Thanks,
Smitha.

Report message to a moderator

Re: Is there any way to prevent a query from executing at run time [message #88692 is a reply to message #88193] Thu, 30 January 2003 22:26 Go to previous message
Murali Venkataraman
Messages: 1
Registered: January 2003
Junior Member
For instance to diable query Q1, try srw.set_maxrow('Q1',0) in before param trigger. Use IF switch to conditionally disable the queries

Report message to a moderator

Previous Topic: Cache problem with PDF and Reports 6i
Next Topic: Oracle Reports Engine
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 17 23:22:22 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.