Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to use AD_DD.REGISTER_TABLE API to register an OBJECT of TYPE !

532175Oct 5 2006 — edited Oct 5 2006
hi intelligentsia,
i have created an object type of TYPE in my custom schema using the following scripts and grant all privileges to APPS schema user and subsequently created synonyms for it in APPS schema. but is there something missing,i;e registering of the object TYPE in APPS schema, and i got an error in registering, so problem could be with the API call,kindly check the API Call in Bold and Revert Back.

In Custom Schema CLE

CREATE OR REPLACE TYPE cle_f006_inv_tp
AS OBJECT
(invoice_id varchar2(250),error_code varchar2(250),description varchar2(250));

CREATE OR REPLACE TYPE cle_f006_inv_tbl AS TABLE OF cle_f006_inv_tp;

GRANT ALL ON cle_f006_inv_tp TO APPS;

GRANT ALL ON cle_f006_inv_tbl TO APPS;

In APPS Schema APPS

CREATE SYNONYM cle_f006_inv_tp FOR cle.cle_f006_inv_tp ;

CREATE SYNONYM cle_f006_inv_tbl FOR cle.cle_f006_inv_tbl ;

EXECUTE AD_DD.REGISTER_TABLE(P_APPL_SHORT_NAME=>'CLE',P_TAB_NAME=>'CLE_F006_INV_TP',P_TAB_TYPE=>'TYPE');

so when i tried registering my following TYPES in APPS schema with following API Calls, it fails and if i use P_TAB_TYPE parameter as 'T', it works but will that suffice? please comment .

Thanks In Anticipation.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 2 2006
Added on Oct 5 2006
1 comment
2,843 views