Search notes:

ORA-65503: cannot send or receive temporary LOB locators over a database link

This statement is ok.

select sql_text     from v$sql@db_far_away;

sql_fulltext is a CLOB and cannot be transmitted over a database link:

select sql_fulltext from v$sql@db_far_away;
-- ORA-65503: cannot send or receive temporary LOB locators over a database link
-- ORA-02063: preceding line from XYZ

TODO

I was unable to replicate the error message in 23c.

ORA-65503: cannot send or receive temporary LOB locators over a database link

TODO

See also