Postgres Pro
Downloads
Home   >   mailing lists

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

From Vyacheslav Kalinin
Subject Re: Read a CLOB data from an Oracle table and INSERT it into a BYTEA column in Postgres using jdbc?
Date
Msg-id 9b1af80e0903301525j578ded88g8c4a6fadcd8aec0e@mail.gmail.com
Whole thread Raw
In response to Read a CLOB data from an Oracle table and INSERT it into a BYTEA column in Postgres using jdbc?  (SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: MargaretGillon@chromalloy.com
Date:
Subject: Schema for J2EE project
Next
From: Michael Glaesemann
Date:
Subject: Re: i have a problem with judge some words contain chinese word!