Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: SHARMILA JOTHIRAJAH <sharmi_jo@xxxxxxxxx>
Subject: Re: Read a CLOB data from an Oracle table and INSERT it into a BYTEA column in Postgres using jdbc?
From: Vyacheslav Kalinin <vka@xxxxxxxx>
Date: Tue, 31 Mar 2009 02:25:16 +0400
Cc: General postgres mailing list <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <520691.57660.qm@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>

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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Read a CLOB data from an Oracle table and INSERT it into a BYTEA column in Postgres using jdbc?
  - From: SHARMILA JOTHIRAJAH

Prev by Date: Schema for J2EE project
Next by Date: Re: i have a problem with judge some words contain chinese word!
Previous by thread: Read a CLOB data from an Oracle table and INSERT it into a BYTEA column in Postgres using jdbc?
Next by thread: Optimization Wizard
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux