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
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