Location: The Official Oracle Wiki

Discussion: Database link/how to fetch dataReported This is a featured thread

Category: Discussion Forum / General Discussion
Showing 2 posts

monojit00
Database link/how to fetch data
Oct 22 2009, 4:36 PM EDT | Post edited: Oct 22 2009, 4:36 PM EDT
i have created a database link, i am able to fetch data by giving the following query..

select a,b,c from Schema.Table@DB_LinkName

(i have 4 columns namely a,b,c,d where a,b,c are of varchar2 type and column d is of CLOB type)

But i am not able to fetch columns which is CLOB type ie column "d".

following query results an error as b is of CLOB type.
select a,b,c,d from Schema.Table@DB_LinkName

Can anyone please help me to sort this out..!!! Do you find this valuable?    

naveenhks
1. RE: Database link/how to fetch data
Oct 23 2009, 2:12 PM EDT | Post edited: Oct 23 2009, 2:12 PM EDT
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:52297289480186

Check this above link in asktom site Do you find this valuable?    

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)
Transfering Conventional data values to XML and store in CLOBS