Skip to Main Content

Oracle Forms

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!

Form Closes While Compiling

Stalin EphraimJul 20 2010 — edited Jul 23 2010
Dear,

I have a form, using views which has tables from other databases.
eg:my database name is G1 here i have a view

MR_HEAD

CREATE OR REPLACE VIEW MR_HEAD AS
SELECT "MR_HEAD_KEY","MR_TRAN_TYPE","MR_NO","MR_DATE","PO_TYPE","PO_NO","VENDOR_CODE","MODIFY_FLAG","SUPERSEDE_FLAG","REF_MR_HEAD_KEY","PO_KEY","PO_DATE","REJECTION_NO","USER_ID","LAST_UPD_DATE"
FROM INMATMAS.MR_HEAD@SPICFIN



i am linking my database G1 with Above Database.
so after using this in my form as 'INMATMAS.mr_head@DB_OPTIMAT'
for insert/select.

i cant able to compile it. form closes immly when i compile this.

what must be the reason, pls help.

Stalin Ephraim
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 20 2010
Added on Jul 20 2010
16 comments
2,657 views