Select Code to Download

TYPE myTable IS TABLE OF DeptTable%rowtype INDEX BY BINARY_INTEGER;

CREATE OR REPLACE PACKAGE foo AS

...
    END getDept;

END foo;

my $dbh =DBI->connect('dbi:Oracle:host=hostname;sid=theSID',
        'user',
...
}

$dbh->disconnect;

CREATE OR REPLACE PACKAGE foo AS

...
    END getAllDept;

END foo;

use Data::Dumper;

...
}

$dbh->disconnect;

Execution of stored procedure failed because:
ORA-06550: line 3, column 4:
PLS-00306: wrong number or types of arguments in call to 'GETALLDEPT'
ORA-06550: line 3, column 4:
PL/SQL: Statement ignored (DBD: oexec error)