HELP - Forms data blocks mapped to stored procedures

From: Ken Grierson <ken_grierson_at_sol.co.uk>
Date: Thu, 02 Sep 1999 22:26:25 +0100
Message-ID: <37CEEB81.30A20D51_at_sol.co.uk>

Hi Folks

I can get a Forms 6 data block to use a stored procedure that returns a REF CURSOR, but can anyone send or point me to an example of a stored procedure that returns a table of rows.
The server is Oracle 8i v 8.1.5

CREATE OR REPLACE PACKAGE pck_emp IS
TYPE emp_cur is REF CURSOR RETURN emp%rowtype; TYPE ename_tab IS TABLE OF emp.ename%TYPE;
--

• This procedure maps fine PROCEDURE query( resultset IN OUT emp_cur );
  --
  
• Forms FRM-10764: No argument of type TABLE or REFCURSOR
• The wizard thinks p_ename is VARCHAR2 PROCEDURE query2( p_ename IN OUT ename_tab ); END; / show errors

CREATE OR REPLACE PACKAGE BODY pck_emp IS

    PROCEDURE query(resultset IN OUT emp_cur ) IS     BEGIN

      OPEN resultset FOR
      SELECT *
      FROM emp;

    END;
  --
  PROCEDURE query2(
    p_ename IN OUT ename_tab
  ) IS
  BEGIN
    SELECT ename
    BULK COLLECT INTO p_ename
    FROM emp;
  END;
  --
END;
/
show errors

TIA Ken Grierson Received on Thu Sep 02 1999 - 23:26:25 CEST