Skip to Main Content
  • Questions

  • How to fetch the clob column using the db link

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Gobinath.

Asked: June 10, 2024 - 4:29 pm UTC

Last updated: June 13, 2024 - 2:44 am UTC

Version: 4.1.3

Viewed 1000+ times

You Asked

I want to validate the clob column from the source table using db link, but I am not able to fetch the clob column from the source table via db link. I am not having any permissions to the source db(create view/create table/PLSQL execution) other than read access. Is that any other way to fetch the record from source db using db link. It also having more than 4000 byte, if it is less than 4000 we might use to_char to fetch the records from the source db.

and Connor said...

Easy fix...


Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

CLOB Column error in DB link

Gobinath, June 11, 2024 - 5:42 am UTC

Yes got the picture, but I tried the same like

1. Created the temp table in the target db and tried to insert the CLOB column from the source table

2. Created the global temp table in the target db and tried to insert the CLOB column from the source table

Both are throwing the same error ORA 22992

Is that any criteria to be satisfied to insert the CLOB column from the source table. (Say, while creating the db link we need to mention something).

Connor McDonald
June 13, 2024 - 2:44 am UTC

Well... we can't see your test case, your code, your data, your output....so its tough for us to comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

CLOB/BLOB/etc

Complete documentation on Securefiles and Large Objects here