Table Registration Example

TABLE REGISTRATION:
NOTE: CONNECT TO CUSTOM Schema (WIP) --WIP/WIP@PROD

1)CREATE TABLE CUSTOM_VENDORS

2) GRANT ALL ON CUSTOM_VENDORS TO APPS;

3) CONN APPS/APPS@PROD

4) CREATE PUBLIC SYNONYM CUSTOM_VENDORS FOR PO.CUSTOM_VENDORS;

5) EXEC AD_DD.REGISTER_TABLE ('PO','CUSTOM_VENDORS','T', 8, 10, 90);

6) EXEC AD_DD.REGISTER_COLUMN ('PO','CUSTOM_VENDORS','VENDOR_ID', 1,'NUMBER', 10,'N','Y');

NOTE: REGISTER ALL COLUMNS

7)COMMIT;


VALUE SETS
WHO COLUMNS
FLEXFIELD (DFF,KFF)

==================================================

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production
With the Partitioning option
JServer Release 8.1.7.3.0 - Production

SQL> create table wip_new_items(item varchar2(10),
2 itemdesc varchar2(100),
3 itemcost number(9),
4 created_by number(8),
5 creation_date date,
6 last_updated_by number(8),
7 last_update_date date,
8 attribute_category varchar2(150),
9 attribute1 varchar2(150),
10 attribute2 varchar2(150),
11 attribute3 varchar2(150),
12 attribute4 varchar2(150),
13 attribute5 varchar2(150));

Table created.

SQL> /
create table wip_new_items(item varchar2(10),
*
ERROR at line 1:
ORA-00955: name is already used by an existing object

SQL> GRANT ALL ON WIP_NEW_ITEMS TO APPS;

Grant succeeded.

SQL> CONN APPS/APPS@PROD
Connected.
SQL> CREATE PUBLIC SYNONYM WIP_NEW_ITEMS FOR WIP.WIP_NEW_ITEMS;

Synonym created.

SQL> EXEC AD_DD.REGISTER_TABLE('WIP','WIP_NEW_ITEMS','T',8,10,90);

PL/SQL procedure successfully completed.

SQL> EXEC AD_DD.REGISTER_COLUMN('WIP','WIP_NEW_ITEMS','ITEM',1,'VARCHAR2',10,'N','Y');

PL/SQL procedure successfully completed.

SQL> EXEC AD_DD.REGISTER_COLUMN('WIP','WIP_NEW_ITEMS','ITEMDESC',2,'VARCHAR2',100,'N','Y');

PL/SQL procedure successfully completed.

SQL> EXEC AD_DD.REGISTER_COLUMN('WIP','WIP_NEW_ITEMS','ITEMCOST',3,'NUMBER',9,'N','Y');

PL/SQL procedure successfully completed.

SQL> EXEC AD_DD.REGISTER_COLUMN('WIP','WIP_NEW_ITEMS','CREATED_BY',4,'NUMBER',8,'N','Y');

PL/SQL procedure successfully completed.

SQL> EXEC AD_DD.REGISTER_COLUMN('WIP','WIP_NEW_ITEMS','CREATION_DATE',5,'DATE',11,'N','Y');

PL/SQL procedure successfully completed.

SQL> EXEC AD_DD.REGISTER_COLUMN('WIP','WIP_NEW_ITEMS','LAST_UPDATED_BY',6,'NUMBER',8,'N','Y');

PL/SQL procedure successfully completed.

SQL> EXEC AD_DD.REGISTER_COLUMN('WIP','WIP_NEW_ITEMS','LAST_UPDATE_DATE',7,'DATE',11,'N','Y');

PL/SQL procedure successfully completed.

SQL> EXEC AD_DD.REGISTER_COLUMN('WIP','WIP_NEW_ITEMS','ATTRIBUTE_CATEGORY',8,'VARCHAR2',150,'N','Y')
;

PL/SQL procedure successfully completed.

SQL> EXEC AD_DD.REGISTER_COLUMN('WIP','WIP_NEW_ITEMS','ATTRIBUTE1',9,'VARCHAR2',150,'N','Y');

PL/SQL procedure successfully completed.

SQL> EXEC AD_DD.REGISTER_COLUMN('WIP','WIP_NEW_ITEMS','ATTRIBUTE2',10,'VARCHAR2',150,'N','Y');

PL/SQL procedure successfully completed.

SQL> EXEC AD_DD.REGISTER_COLUMN('WIP','WIP_NEW_ITEMS','ATTRIBUTE3',11,'VARCHAR2',150,'N','Y');

PL/SQL procedure successfully completed.

SQL> EXEC AD_DD.REGISTER_COLUMN('WIP','WIP_NEW_ITEMS','ATTRIBUTE4',12,'VARCHAR2',150,'N','Y');

PL/SQL procedure successfully completed.

SQL> EXEC AD_DD.REGISTER_COLUMN('WIP','WIP_NEW_ITEMS','ATTRIBUTE5',13,'VARCHAR2',150,'N','Y');

PL/SQL procedure successfully completed.

SQL> COMMIT;

Commit complete.

SQL>