Package-defined type as column type

From: NiTiN <k.nitin.r_at_gmail.com>
Date: Sun, 3 Feb 2008 04:41:33 -0800 (PST)
Message-ID: <1db0b62e-a12c-4134-99ab-909f3371dc07@k2g2000hse.googlegroups.com>


Good day,

I'm trying to use a package-defined type as the data type for a column in an Oracle table and am trying to figure out how to get it to work. I'm guessing package-defined types can't be used as column data types.

Here's a sample:
CREATE OR REPLACE PACKAGE pkg1_test
IS
  TYPE usersource AS OBJECT (
    sourceinfo VARCHAR2(1024),
    sourcetype CHAR(1)
  );
END pkg1_test;

CREATE TABLE test1 (
id INTEGER,
val pkg1_test.usersource
);

-NiTiN Received on Sun Feb 03 2008 - 06:41:33 CST

Original text of this message