Oracle REF Cursors

[Peter Bateman]

John:

  A reference cursor should work in a manner similiar to a reference file 
although I had not tried it.

  Reference files are read when:-

  1) a defined item that is based on an item in the reference file is 
referenced.
  2) when a lookup occurs on the reference file.
  3) As part of the FIND processing if an item from the reference
     file is displayed.

You will probably want to use a host variable in the cursor definition.
   DECLARE P_ORDERS FOR SELECT ORDER_NO, CUST_NO


   DECLARE LOOKUP_CUSTOMERS FOR SELECT CUST_NAME FROM CUSTOMERS C  &
                         WHERE C.CUST_NO = :CUST_NO OF P_ORDERS


   CURSOR P_ORDERS PRIMARY

   CURSOR LOOLUP_CUSTOMERS REFERENCE

; ORDERS MUST HAVE A VALID CUSTOMER NUMBER
   FIELD CUST_NO OF P_ORDERS LOOKUP ON LOOKUP_CUSTOMERS
   FIELD CUST_NAME OF LOOKUP_CUSTOMERS ID SAME DISPLAY

Regards,
Peter Bateman


>From: "John Hunter" <jthunter@nbnet.nb.ca>
>To: <powerh-l@lists.swau.edu>
>Subject: Oracle REF Cursors
>Date: Wed, 18 Dec 2002 09:06:28 -0400
>
>Hi,
>
>Does anyone know if it's possible to access an
>Oracle Procedure that returns a REF Cursor from Powerhouse?
>
>We are able to declare cursors and use them in powerhouse, but
>we haven't found a way to use a ref cursor returned from a oracle
>procedure.
>
>Any hints?
>
>We are Using Oracle 8.1.7.4.0 and PowerHouse  8.20.D7 on Open VMS
>
>Thanks,
>-John
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.swau.edu
>Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
>Unsubscribe: "unsubscribe" in message body to 
>powerh-l-request@lists.swau.edu
>http://lists.swau.edu/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.


_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail