database link not compiling from form 6i patch 17
761511Mar 21 2010 — edited Mar 21 2010Hi scholars,
Recently i urgraded my oracle form 45 to form 6i and everything gone right except the database link to 10g oracle database.
The form 6i is connected to oracle 8i database and working fine too.. From form 45 database link to 10g was worked well.
After upgrading it is not able to compile the database link, it shows the error ORA-04054 databse link does not exist.
From SQL all these works fine.
my procedure looks like as follows:-
DJV_TYPE MASTER_JOURNAL@AMWAL_DATA.MJ_TYPE%TYPE := 1;
DMJ_DOCNO MASTER_JOURNAL@AMWAL_DATA.MJ_DOCNO%TYPE;
CURSOR GET_DOC_NO IS
SELECT NVL(MAX(MJ_DOCNO), 0) + 1 FROM MASTER_JOURNAL@AMWAL_DATA
WHERE MJ_TYPE = 1;
please, anybody can help me regarding this..