Issue with ora2pg 12.1 connecting to Oracle 8i (works with 11.4) about ora2pg HOT 9 CLOSED

Thanks for the report, could you please execute ora2pg 12.1 again with the -d option and add the result to this issue?

Regards,

from ora2pg.

command:

ora2pg -d -c conf/ora2pg.conf -t SHOW_TABLE

output

Trying to connect to database: dbi:Oracle:host=;sid=
Isolation level: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
Auto detecting Oracle character set and the corresponding PostgreSQL client encoding to use.
Using Oracle character set: AMERICAN_AMERICA.WE8ISO8859P1.
Using PostgreSQL client encoding: LATIN1.
Showing table information...
FATAL:
Aborting export...

Regards

from ora2pg.

Ok, thanks for the report. The error message is not really useful but maybe the error comes from the materialized view listing introduced before displaying table information. I have patched ora2pg to change level of the error message when querying materialized view to continue even if there's an error.

Could you test latest code from github and let us know if it solves the issue.

Regards,

from ora2pg.

Hi, I've pulled the latest code (with the changes in the .pm module). But result stays the same.
:-(

FATAL:
Aborting export...

Regards

from ora2pg.

Ok. Ive enumerated all the FATAL "echos" in the Ora2Pg.pm and btw there are a lot of them... ;-)
The FATAL which is triggered is in Line 4249

4243 my $ret = $self->{dbh}->err;
4244 if (!$recurs && ($ret == 942) && ($self->{prefix} eq 'DBA')) {
4245 $self->logit("HINT: Please activate USER_GRANTS or connect using a user with DBA privilege.\n");
4246 $self->{prefix} = 'ALL';
4247 return $self->_column_info($table, $owner, 1);
4248 }
4249 $self->logit("50FATAL: " . $self->{dbh}->errstr . "\n", 0, 1);
4250 }

Hope that helps. Regards

from ora2pg.

I'm trying to install a 8i on a VM with a help of colleague to be able to reproduce the issue. It takes time because it is a task that required some knowledge of palaeontology :-(

from ora2pg.

Ok. I think I found the solution. It was a missing if(!$sth)
I have commited it as a patch in my forked repository
c1acafc
hope thats right. I'm new to this github thing ;-)

from ora2pg.

.... aaaaaaaaand forgot to close the if statement
740d45f
Seems to work with '-t SHOW_TABLE' going for a test run tomorrow (the export takes a while) and report back

from ora2pg.

Good catch, commit 20b8327 applied your patch. At least now, thanks to you and Marco I have a running 8i for testing :-)

from ora2pg.