Re: HELP!!! Please I need FORMS 4.0 HELP!!!

From: Steve Cosner <stevec_at_zimmer.CSUFresno.EDU>
Date: 1995/07/10
Message-ID: <DBIt6G.2MB_at_CSUFresno.EDU>#1/1


In article <3tr5n8$7ro_at_data.interserv.net>tls1035_at_dpcmail.dukepower.com   writes:

>I'm a inexperienced FORMS 4.0 user. Can anyone tell me how to
declare a cursor within FORMS 4.0. Can this be accomplished and if so, HOW?????.  

In a PL/SQL procedure:  

Procedure EXAMPLE (param1, param2) is
  tempvar1 varchar2(5);
  tempvar2 number;
  cursor XYZ <PUT YOUR CURSOR SQL HERE> BEGIN
  open ...    

This is pretty cryptic, and I'm writing from memory, but cursors are not difficult in Forms.

If you want a cursor in a trigger, replace the line starting with "Procedure" with "Declare", and all the rest is the same.  

Hope this helps  

Steve Cosner (stevec_at_csufresno.edu)     Received on Mon Jul 10 1995 - 00:00:00 CEST

Original text of this message