AW: Help with semi colons and Oracle blocks through dbi

[Peter . Bruhn]

Somthing like

my $block_count = 0;
while(<STDIN>) {
    $block_count++ if /[bB][eE][gG][iI][nN]/;
    s/;//g if $block_count == 0;
    $block_count-- if /[eE][nN][dD];/;
    print;
}

should remove your colons, assuming that BEGIN and END lines have no other
commands, and there are no colons in strings and stuff, and BEGIN and END
does not show up in strings, table names, table columns,...

Peter
-----Urspr�ngliche Nachricht-----
Von: Dave Anderson [mailto:[EMAIL PROTECTED]]
Gesendet am: Mittwoch, 13. Juni 2001 18:29
An: Michael A. Chase
Cc: Mark Vandenbroeck; [EMAIL PROTECTED]
Betreff: Re: Help with semi colons and Oracle blocks through dbi

"Michael A. Chase" wrote:
> 
> The semicolons are needed __inside__ the PL/SQL blocks and on the block
END
> statement.

I see, so it's not going to be trivial to take an input file created for
sqlplus and execute it via dbi, because there are two types of semi
colons in the input file. That's really the issue I have.

Thanks anyway, I'll get round it.

cheers
Dave