FRM-10763, no apparent reason

From: Doug Miller <spambait_at_milmac.com>
Date: Fri, 23 May 2008 12:58:19 GMT
Message-ID: <LbzZj.263$xZ.139@nlpi070.nbdc.sbc.com>


Strange thing... trying to build a data block in Forms Builder using the DB Wizard. Block is to be based on a stored procedure. Getting this error:

FRM-10763: Argument of type TABLE or REFCURSOR must be IN OUT.

Cause should be obvious, right? Except that it already *is* IN OUT. Here's the package specification and the first few lines of the package body:

CREATE OR REPLACE PACKAGE jc_conduct_pkg IS

   TYPE conduct_summary_rec IS RECORD

       ( case_no           VARCHAR2(12)

, hearing_dt VARCHAR2(20)
, offense_desc VARCHAR2(50)
, sanction_desc VARCHAR2(24)
, appeal_result VARCHAR2(20)
, prior_commitment VARCHAR2(1)
); TYPE conduct_summary_table IS TABLE OF conduct_summary_rec INDEX BY BINARY_INTEGER; PROCEDURE jc_conduct_summary (off_id IN OUT VARCHAR2, cond_summ_tbl IN OUT conduct_summary_table);
END; CREATE OR REPLACE PACKAGE BODY jc_conduct_pkg IS
   PROCEDURE jc_conduct_summary (off_id        IN OUT VARCHAR2,
                                 cond_summ_tbl IN OUT conduct_summary_table) 
IS
      CURSOR cond_summ_cur (p_id IN OUT VARCHAR2) IS
          SELECT ...

Any help appreciated.

Environment:

Forms [32 Bit] Version 10.1.2.0.2 (Production) Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production

     With the Partitioning, OLAP and Data Mining options Oracle Toolkit Version 10.1.2.0.2 (Production) PL/SQL Version 10.1.0.4.2 (Production)
Oracle Procedure Builder V10.1.2.0.2 - Production Received on Fri May 23 2008 - 07:58:19 CDT

Original text of this message