- or download this
begin
forbesc.test_exception_pg.main('orafail');
end;
/
exit
- or download this
#!/usr/bin/perl -w
my $sqlplus = "sqlplus -s chuckster/im_in\@develo";
...
my $var = (system($sqlplus . " " . $file));
my $out = $? >> 8;
print "The out value is '$out'.\n";
- or download this
[prodadm@ora4 scripts]$ ./invoke_sqlplus.pl
begin
...
The out value is '0'.