#3 sub read_view_from_file

[Anonymous]

in sub read_view_from_file in ora2pg.pm

while ($content =~ s/CREATE\sVIEW[\s]+([^\s]+)\s((.?))\s+AS\s+([^;]+);//i) {
my $v_name = $1;
$v_name =~ s/"//g;
my $v_alias = $2;
my $v_def = $3;

Should be
while ($content =~ s/CREATE\sVIEW[\s]+([^\s]+)\s((.?))\s+AS\s+([^;]+);//i) {
my $v_name = $1;
my $v_alias = $2;
my $v_def = $3;
$v_name =~ s/"//g;

Because after $v_name =~ s/"//g; $2 $3 and respectively $v_alias, $v_def will be null.

[Darold Gilles]

Fixed in github commit f1c423e