Hi,
I am experiencing some strange problems.
I have created a PUBLIC SYNONYM using DBA account.
CREATE OR REPLACE PUBLIC SYNONYM table_1 FOR table@dblink
I then log into the databse (user schema) using sql and run the following statement:
select count from table_1;
Result = 1000 rows = correct
I then log into APEX (same user schema) and run the same query in SQL Workshop.
Result = 200 rows
Has anybody experienced this problem?
APEX version 2.2.1.00.04
DB 10g R2
Thanks in advance
VC