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_at_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 - 14:58:19 CEST