Tried to query a table from a DB-Link but some columns are CLOBS, so it doesnt like it.
Created temporary tables in APEX, linking them to the remote table using this method -
CREATE GLOBAL TEMPORARY TABLE localtable_name
ON COMMIT PRESERVE ROWS AS
SELECT * FROM remotetable_name@DB-LINK
I insert data using this method -
insert into localtable_name Select * from remotetablename@DB-LINK;
but yet it shows no data in the table and no data when i run a application page with a report on it.
Any ideas as to what im doing wrong?
Thanks in advance