Hi!!See www.orafaq.com/forum/mv/msg/4467/12407/0 for the original post.
I am with one doubts, I mounted one procedure that to need to return a cursor.
The STRING SQL is must be twirled half ample in the "WHERE".
For that haven't to make varios ifs, would like to know if is possible to create one parameter that it comes with where and to place in the routine to twirl, I tried to make this but not gave certain.
It below follows:OPEN RCURSOR FOR SELECT * FROM TABELA1 WHERE CAMPO1 < 10 || VARIAVEL1
In var(VARIAVEL1) it would be:'AND CAMPO2 = 3 AND CAMPO3 > = 25'
For example, this would be possible?
Or I will have exactly that to mount one 'IF' giant for to treat all the routine.
Friday, September 09, 2005
It is of course completely unfair to post this message by someone who clearly does not speak English. Actually you have to admire his valiant effort to describe a problem with dynamic ref cursors in a foreign language, through what must be the world's most eccentric translation software, or possibly using only a rather old dictionary. (Credit also goes to Art Metzer who actually provided a solution.) But it remains our all-time favourite Oracle forum post, so here it is:
Posted by William Robertson at 1:10 pm