Re: Read a CLOB data from an Oracle table and INSERT it into a BYTEA column in Postgres using jdbc?

From: Vyacheslav Kalinin <vka(at)mgcp(dot)com>
To: SHARMILA JOTHIRAJAH <sharmi_jo(at)yahoo(dot)com>
Cc: General postgres mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Read a CLOB data from an Oracle table and INSERT it into a BYTEA column in Postgres using jdbc?
Date: 2009-03-30 22:25:16
Message-ID: 9b1af80e0903301525j578ded88g8c4a6fadcd8aec0e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

You are fetching an Oracle LOB locator. I am not a guru of OCI let alone
JDBC but AFAIK you should create a LOB descriptor, bind it to the locator
and load the LOB data that you can insert into postgres.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2009-03-30 22:52:32 Re: i have a problem with judge some words contain chinese word!
Previous Message Osvaldo Kussama 2009-03-30 21:01:19 Re: Optimization Wizard