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>
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