Create a data block based on stored procedure

From: shendg <shendg_at_hotmail.com>
Date: 11 Sep 2003 09:13:20 -0700
Message-ID: <62376118.0309110813.255c281e_at_posting.google.com>

Hi to all,

I am using Form Builder 6.0

I use REF CURSOR in my procedure. The procedre looks like this:

Package sdds_maint
AS
  TYPE sdds_info IS RECORD(

  sdds_id        sdds.sdds_id%TYPE,
  sdds_des       sdds.desc%TYPE);

TYPE rc_sddsinfo IS REF CURSOR
  RETURN sdds_info;

PROCEDURE slct (
  p_sddsinfo IN OUT rc_sddsinfo);
END; PROCEDURE slct(
  p_sddsinfo IN OUT rc_sddsinfo)
IS
BEGIN
  OPEN p_sddsinfo
  FOR

     SELECT sdds_id, sdds_desc
     FROM sdds;

END; However, for some reason, the QUERY-PROCEDURE Trigger is not automatically created by FORM Builder. I don't get any error message except FRM-40505 "unable to perform query". I guess that is because the QUERy-PROCEDURE Trigger is not crated.

Do I forget to set up something....

Thank you for your help!!

shendg Received on Thu Sep 11 2003 - 18:13:20 CEST