ODM TEST:
[oracle@vrh8 ~]$
[oracle@vrh8 ~]$ cat type.sql
CREATE TYPE customer_typ_demo AS OBJECT
( customer_id NUMBER(6)
, cust_first_name VARCHAR2(20)
, cust_last_name VARCHAR2(20)
, nls_language VARCHAR2(3)
, nls_territory VARCHAR2(30)
, credit_limit NUMBER(9,2)
, cust_email VARCHAR2(30)
)
/
[oracle@vrh8 ~]$
[oracle@vrh8 ~]$
[oracle@vrh8 ~]$ wrap iname=type.sql oname=type.plb
PL/SQL Wrapper: Release 10.2.0.5.0- 64bit Production on Mon Jul 02 08:34:42 2012
Copyright (c) 1993, 2004, Oracle. All rights reserved.
Processing type.sql to type.plb
[oracle@vrh8 ~]$ cat type.plb
CREATE TYPE customer_typ_demo wrapped
a000000
1
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
d
12c f7
BJwRUO7nmexqVOYoLqGY8WkpTNgwg3lyACisZ3Q5cBeqlfDIfARZWXaZw9i+KF7Ltuj9ifdw
jlu17Uk1RA2EB4uhmjwrEo7GBQ32E5IGRfgxkPzolGnnt4p8Dcfu1S/ek1SMyKQB4BZM5Tat
VAIA9CMG39u89mnOdhyp62K4dttt9PF85rWJpwKAe5aoxqi5O6cLkfdY2O78/RDhiIKb9xqF
3JYPgAhdxcNnm4FVu+W4M6YDEuk/
/
[oracle@vrh8 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Mon Jul 2 08:35:12 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
SQL>
SQL> CREATE TYPE customer_typ_demo wrapped
2 a000000
3 1
4 abcd
5 abcd
6 abcd
7 abcd
8 abcd
9 abcd
10 abcd
11 abcd
12 abcd
13 abcd
14 abcd
15 abcd
16 abcd
17 abcd
18 abcd
19 d
20 12c f7
21 BJwRUO7nmexqVOYoLqGY8WkpTNgwg3lyACisZ3Q5cBeqlfDIfARZWXaZw9i+KF7Ltuj9ifdw
22 jlu17Uk1RA2EB4uhmjwrEo7GBQ32E5IGRfgxkPzolGnnt4p8Dcfu1S/ek1SMyKQB4BZM5Tat
23 VAIA9CMG39u89mnOdhyp62K4dttt9PF85rWJpwKAe5aoxqi5O6cLkfdY2O78/RDhiIKb9xqF
24 3JYPgAhdxcNnm4FVu+W4M6YDEuk/
25
26 /
Type created.
SQL> select text from dba_source where name='CUSTOMER_TYP_DEMO';
TYPE customer_typ_demo wrapped
a000000
1
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
d
12c f7
BJwRUO7nmexqVOYoLqGY8WkpTNgwg3lyACisZ3Q5cBeqlfDIfARZWXaZw9i+KF7Ltuj9ifdw
jlu17Uk1RA2EB4uhmjwrEo7GBQ32E5IGRfgxkPzolGnnt4p8Dcfu1S/ek1SMyKQB4BZM5Tat
VAIA9CMG39u89mnOdhyp62K4dttt9PF85rWJpwKAe5aoxqi5O6cLkfdY2O78/RDhiIKb9xqF
3JYPgAhdxcNnm4FVu+W4M6YDEuk/
在另一个数据库中
SQL> create TYPE customer_typ_demo wrapped
2 a000000
3 1
4 abcd
5 abcd
6 abcd
7 abcd
8 abcd
9 abcd
10 abcd
11 abcd
12 abcd
13 abcd
14 abcd
15 abcd
16 abcd
17 abcd
18 abcd
19 d
20 12c f7
21 BJwRUO7nmexqVOYoLqGY8WkpTNgwg3lyACisZ3Q5cBeqlfDIfARZWXaZw9i+KF7Ltuj9ifdw
22 jlu17Uk1RA2EB4uhmjwrEo7GBQ32E5IGRfgxkPzolGnnt4p8Dcfu1S/ek1SMyKQB4BZM5Tat
23 VAIA9CMG39u89mnOdhyp62K4dttt9PF85rWJpwKAe5aoxqi5O6cLkfdY2O78/RDhiIKb9xqF
24 3JYPgAhdxcNnm4FVu+W4M6YDEuk/
25
26 /
Type created.