OraFAQ Forum: Other Application Suites » Table Registation problem

Home » Applications » Other Application Suites » Table Registation problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Table Registation problem [message #343403]

Wed, 27 August 2008 03:42

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

Report message to a moderator

[Message index]

		Table Registation problem By: jaganerp@gmail.com on Wed, 27 August 2008 03:42
		Re: Table Registation problem By: vamsi kasina on Sat, 04 April 2009 11:20

Previous Topic:	Interface Documents for Customer Item & Bills of Material
Next Topic:	Need study document for -Oracle ECM Tools

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 21:29:45 CDT 2024