Toad 17.1.717.3711 x64
Oracle DB 19.25 x64 (source and remote)
As picture shows BLOBS are not shown when F4 is initiated from Editor, regardless BLOB do exists (select part)
Oh, I just saw that you said "remote database". I missed the fact that you were going through a DB Link in my first reply.
That's why they are excluded. You can't select BLOB/CLOB through a DB Link. If your table had data in it, the query in the editor would have given you an error.
Do you see my first pic? Select works!
I am using synonym that represent table with blob columns through db_link.
Select should always work.
AFAIK, DML is not possible with classic actions, but only as part of some table columns that are sent to db_link table.
Insert in blob with dblink
I see your first pic, but I don't see any data (only a result with no rows). Can you get it to work when rows are returned and the blob/clob values are not null? I get errors in that case.
If it works for you, please let me know
- Your client version
- The version of DB that you are connected to
- The version of DB that the DB Link connects to
First, do not understand why should be any data .. returned columns are ok ...isn?t it?
1)
d:\sqlplus_log>sqlplus /nolog
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jan 17 20:51:48 2025
Version 19.23.0.0.0
Copyright (c) 1982, 2023, Oracle. All rights reserved.
SP2-0640: Not connected
20:51:48 @>
2 and 3 are already in initial post placed:
Oracle DB 19.25 x64 (source and remote)
Thanks. I'll take another look at this on Monday. I know it was a problem with older clients. Maybe it is not anymore. We can at least make it an option.
As a workaround, you can always click the view/edit query button in schema browser to change the SQL to include the missing columns.
Have a nice weekend.
