Database Administration (MOSC)

MOSC Banner

ORA-21700 when selecting SYSDATE in join with remote table

When I do
SELECT SYSDATE,A.ILH_PRD_ID
FROM INV_LINE_HIST@DB.REMOTE ILH
JOIN PRODUCTS@DB.REMOTE P ON ILH.ILH_PRD_ID = P.PRD_ID;

I get ORA-21700.
When I remove sysdate or the join all works fine. Where can be a problem?

OK:
SELECT ILH.ILH_PRD_ID
FROM INVENTORY_LINE_HIST@DB.REMOTE ILH
JOIN PRODUCTS@DB.REMOTE P ON ILH.ILH_PRD_ID = P.PRD_ID;

OK:
SELECT SYSDATE,ILH.ILH_PRD_ID
FROM INVENTORY_LINE_HIST@DB.REMOTE ILH;

OK:
SELECT SYSDATE,p.prd_id
FROM PRODUCTS@DB.REMOTE P;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center