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 -> Oracle forms 5

Oracle forms 5

From: <mdsouza_at_my-dejanews.com>
Date: Fri, 31 Jul 1998 09:18:14 GMT
Message-ID: <6ps24m$rr9$1@nnrp1.dejanews.com>


Hi

Not sure this message got posted

I am using oracle forms 5 and what I am trying to do is measure performance when retrieving data using a table and a stored procedure. The easy bit is using the table to retrieve data the hard bit if trying to use a stored procedure to return data

Oracle suggest to use a REF cursor or a table of records to return the data tat you want to display in the block

I have not got a clue on how to do this. Is there anyone who can show to how to write this procedure just using the EMP table to return data on all the columns

any help would be appreciated

Would be greatful if you could email me on mdesouza_at_yahoo.com

Thanks

Michael Dsouza

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Jul 31 1998 - 04:18:14 CDT

Original text of this message

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