Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Q - OWS21: owa_util.cellsprint with parameters in query?
Hi,
I would like to have a user enter some values, then build a query with those values and finally print out a Table with the results of this query. Seems to be easy up to here. But as the table can be quite big, I would like to use owa_util.cellsprint for printing only 20 records at once, then waiting for the next 20 or showing the previous 20.
Unfortunatelly something like
owa_util.cellsprint( 'select * from test.foo where test.foo.bar like searchstring', 20, 'Yes', p_start, l_more_data );
with searchstring beeing a PL/SQL variable does not work!
It seems to me that cellsprint only accepts static queries, and I did not find cellsprint in the documentation of Ows21.
Do I have to write a PL/SQL procedure with cursors?
Thanks for any hint, Gerhard.
-- Dipl. Inform. Gerhard Möller -- Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.DE OFFIS | | | | | | Tel.: 0441/9722-122 Escherweg 2 | | | | | | Sekr.: 0441/9722-113 oder -101 D-26121 Oldenburg |O|F|F|I|S| Fax: 0441/9722-102Received on Tue Jul 15 1997 - 00:00:00 CDT