How to use AD_DD.REGISTER_TABLE API to register an OBJECT of TYPE !
532175Oct 5 2006 — edited Oct 5 2006hi 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.