Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> D2K 2.0 : BLOCKS BASED ON STORED PROCEDURES

D2K 2.0 : BLOCKS BASED ON STORED PROCEDURES

From: <skhajuria_at_hotmail.com>
Date: Wed, 08 Jul 1998 16:40:19 GMT
Message-ID: <6o07dj$bhp$1@nnrp1.dejanews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US