Note:- The procedure has two IN paramters. First would would have the Application_Short_Name where you want to register the table and Second Paramter would have the table name you want to register.
Note:- Even through, if table is not created and we are trying to register some table name with this procedure, then it will register the table name but with no columns in it.
Note:- After registering the table, if you want to confirm it from Oracle Application Front end then, you can check in Application Developer Responsibility.
Why you need to Register any table in Application?
A) It is important to know, why we need to register any table in the Oracle Application.
If you want to use any table in value set or Oracle Alerts, then you need to
register that table in the Application.
Note:- All we need to give the table name. Rest the values which are needed to register the table or Column in applications would be taken from database automatically. This saves lot of developer time.
I hope you find this post useful in your development work. For any issues or suggestion related to this post, please leave your comment for this post. I will try to reply as soon as possible.
CREATE OR REPLACE PROCEDURE proc_ad_ad
(ap_sname VARCHAR2, ptable_name VARCHAR2)
SELECT ROWNUM, column_name, data_type, data_length
WHERE table_name = upper(ptable_name);
ad_dd.register_table (ap_sname, ptable_name, ‘T’);
EXIT WHEN c1%NOTFOUND;
DBMS_OUTPUT.put_line ( va.ROWNUM
create table phani (col1 varchar2(10), col2 number, col3 date);
In the above Example, we have created the table and trying to register the same table in Application using the Procedure.