Are you sure you are connecting to same database which have the database link object exists ?
Try to compile all the form Shift + Ctrl + K and check that you are connecting to the correct database.
Can you post the code ?
I don´t use the database link directly. The database link was created on BBDD, and synonyms for the objects that I will use.
And it seems that forms don´t recognize it.
This is the code of the database link:
-- Create database link
create database link E73CP00.WORLD
connect to L_TGCPRT10
This is the code of the synonym:
-- Create the synonym
create or replace synonym CPCRT_QOPERACIONADSL
In the form I have a Program Unit, is a procedure, and I declare a variable like this, in the declare section:
In the moment that I put the line declarating the variable I have the error, If I try to call the package in code section I obtain the error too.
When I compile Ctrl + Shift + K: Compilation Complete Succesfully
But the program units, all of the form, have the error:
Error at line 0, column 0
ORA-01041: internal error. hostdef extension doesn´t exists
If is necessarie more information tell me please.
Thanks for th help!
What database versions are you using?
Also, can you try the following?
1. Create a view of the dblink table
2. Test you can successfully select from the view
3. Use this view in the Forms instead of remoteDB table
4. Now compile and test the form