Insertion Error: ORA-22819

From: C Chang <cschang_at_maxinter.net>
Date: Sun, 21 Apr 2002 23:40:48 -0400
Message-ID: <3CC38640.497D@maxinter.net>

It occured in one of my procedure, when one of column was inserted into a table. I believe that the problem is in this section as following:

DECLARE
   v_CodeRef REF supply_T ;
BEGIN
     SELECT REF(A) INTO v_CodeRef FROM fl_supply A WHERE code = v_curCode;

    INSERT INTO fl_part_number
   ( part_number,

       nomen,
       code_r)
   VALUES
 (   v_curPartNum,     -- input parameter
     v_nomen,             --  input parameter

    v_CodeRef);
..
..
-- the fl_part_number is created as

CREATE TABLE fl_part_number OF part_number_T;
-- part_number_T is

CREATE OR REPLACE TYPE part_number_T AS OBJECT ( part_number VARCHAR2(36),

    v_nomen          VARCHAR2(72),
   code_R             REF supply_T

);
-- fl_supply is

CREATE TABLE fl_supply OF supply_T;
-- supply_T is

CREATE OR REPLACE TYPE supply_T AS OBJECT

(    code       VARCHAR2(10),
     status       VARCHAR2(1),
     name       VARCHAR2(16),
     address_T    add_T

)
The procedure did not indicate any insertion error before the supply_t had any data; whoever, as long as there is data of code in supply_t, then the error ORA-22819 appeared. Because I am very new to the object type in ORacle, Does anyone know how to correct this? Thanks

C Chang Received on Sun Apr 21 2002 - 22:40:48 CDT