dbTalk Databases Forums  

FRM-10763, no apparent reason

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss FRM-10763, no apparent reason in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Doug Miller
 
Posts: n/a

Default FRM-10763, no apparent reason - 05-23-2008 , 07:58 AM






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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.