Home » Developer & Programmer » Reports & Discoverer » Reports 6i ref_cursor (Reports 6i)
Reports 6i ref_cursor [message #656805] Wed, 19 October 2016 12:35 Go to next message
petko
Messages: 2
Registered: October 2016
Junior Member
in OraRep 6i, i create rec_cursor with sql. then in the Data MOdel OraRep i create QR.
In the parameter report i have field with 4 option (A, B, C, D) and when user choosse one of the option sql in ref_cursor, i add more then one restriction (AND .......) on the query (ref_cursor).
is it possible to do something like this :

function QR_....
....
open ref_cursor for

if :parameter = A then
ref_cursor || 'AND ........';
elsif
:parameter = B then
ref_cursor || 'AND ........'
AND ........' ;

Re: Reports 6i ref_cursor [message #656809 is a reply to message #656805] Wed, 19 October 2016 14:11 Go to previous messageGo to next message
Littlefoot
Messages: 21612
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't know, I didn't try it. However, when I have to use such a "dynamic" WHERE clause, I create a lexical parameter, set its value in After Parameter Form trigger and use it in a main query; for that option, I *know* it works.
Re: Reports 6i ref_cursor [message #656833 is a reply to message #656809] Thu, 20 October 2016 04:25 Go to previous message
petko
Messages: 2
Registered: October 2016
Junior Member
Lexical in PLSQL ?
Previous Topic: Ho we can use "with t as" in reports query
Next Topic: Print Field Text in Vertical Direction
Goto Forum:
  


Current Time: Sun Oct 25 23:18:07 CDT 2020