sub read_view_from_file
Brought to you by:
darold
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.
Anonymous
Fixed in github commit f1c423e