Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> D2K 2.0 : BLOCKS BASED ON STORED PROCEDURES
Hi,
I have based my forms 5.0 block on a stored procedure. All is working fine.
I now want to programatically order the block on different fields. Can someone tell me that how do we use Order by property of block. usual 4.5 way of set_block_property(...) does not seem to be working. passing parameter to stored procedure is possible but Order by clause of select statement treats the passed variable as constant and does nothing.
Help required...
Thanks (in anticipation!!!)
-Sandeep
-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Wed Jul 08 1998 - 11:40:19 CDT
![]() |
![]() |