Thread: ora2pg fails on LONG object access in Catalog

I recently used the program ora2pg to convert an Oracle 9i database to
Postgress. i had a few problems.

Data stored as /'' in oracle did could not be inserted into postgreSQL (The
/ had to be deleted)

Line 1424 in ora2pm has a select statement that reads in a LONG field
("SEARCH_CONDITION") i changed this to ' '.
Line 1315 alos had a LONG field in the SQL. ("DATA_

I was able to get the program to work, However, I'm sure I'll hit problems
as I need to convert elements (VIEWS, PROCS) that require this info.

I think the problem has to do with the DBD:Oracle module support for 9i...
Has anybody looked into this.


---------------------------------------------------------------------------------------------------------

Arthur Nicewick
American Management Systems
Corporate Technology Group
art_nicewick@ams.com
(703) 267-8569

Quote of the week:
We are what we pretend to be.
  -- Kurt Vonnegut Jr.

Gilles (ora2pg author), have you seen this?

Art Nicewick wrote:
>
> I recently used the program ora2pg to convert an Oracle 9i database to
> Postgress. i had a few problems.
>
> Data stored as /'' in oracle did could not be inserted into postgreSQL (The
> / had to be deleted)
>
> Line 1424 in ora2pm has a select statement that reads in a LONG field
> ("SEARCH_CONDITION") i changed this to ' '.
> Line 1315 alos had a LONG field in the SQL. ("DATA_
>
> I was able to get the program to work, However, I'm sure I'll hit problems
> as I need to convert elements (VIEWS, PROCS) that require this info.
>
> I think the problem has to do with the DBD:Oracle module support for 9i...
> Has anybody looked into this.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026