Home » Applications » Other Application Suites » Table Registation problem
Table Registation problem [message #343403] Wed, 27 August 2008 03:42 Go to previous message
jaganerp@gmail.com
Messages: 63
Registered: April 2008
Member
Hai Friend's

I created one table in non apps user, and given grant's to apps user and created one synonym in apps user and register that form in apps user but that table is not describe in apps user,but i want to create form based on that table, what i will do

i did like this

step1:
----------
CREATE TABLE XXVES_KFF_EMP
(
EMPNO NUMBER(5) PRIMARY KEY,
ENAME VARCHAR2(60) NOT NULL,
JOB VARCHAR2(20) NOT NULL,
SAL NUMBER(10,2) NOT NULL,
CCID NUMBER(38) NOT NULL REFERENCES XXVES_KFF_COMBINATIONS(CCID)
);
step2:
------
grant all on XXVES_KFF_EMP to apps
step3:
------
connect apps/apps@techserver
step4:
--------
EXECUTE AD_DD.register_table ('V-SAT', 'XXVES_KFF_EMP', 'T')
step5:
---------
EXECUTE AD_DD.register_COLUMN('V-SAT','XXVES_KFF_EMP','EMPNO',1,'NUMBER',5,'N','N')
EXECUTE AD_DD.register_COLUMN('V-SAT','XXVES_KFF_EMP','ENAME',2,'VARCHAR2',60,'N','N')
EXECUTE AD_DD.register_COLUMN('V-SAT','XXVES_KFF_EMP','JOB',3,'VARCHAR2',20,'N','N')
EXECUTE AD_DD.register_COLUMN('V-SAT','XXVES_KFF_EMP','SAL',4,'NUMBER',10,'N','N',2)
EXECUTE AD_DD.register_COLUMN('V-SAT','XXVES_KFF_EMP','CCID',5,'NUMBER',38,'N','N')
step6:
-----
desc XXVES_KFF_EMP;

now it's giving error object not exit
 
Read Message
Read Message
Previous Topic: Interface Documents for Customer Item & Bills of Material
Next Topic: Need study document for -Oracle ECM Tools
Goto Forum:
  


Current Time: Fri Jan 24 14:00:45 CST 2020