help!.... problem with calling procedure..

[Maarten Stolte]

Hello,

I keep on getting:

----
[Thu Dec 13 15:26:00 2001] [error] DBD::Oracle::st execute failed:
ORA-06550: line 3, column 9:
PLS-00306: wrong number or types of arguments in call to 'PROCESS_XML'
ORA-06550: line 3, column 9:
PL/SQL: Statement ignored (DBD ERROR: OCIStmtExecute) at script.
---


when i call a procedure which needs 2 parameters, one in, one out..
The procedure works, but in MODPERL it fails..

This is my perl code:

$datasource  = 'dbi:Oracle:host=.nl;port=1521;sid=xxx';
$db_username = 'user';
$db_password = 'pass';

        $dbh = DBI->connect(
                $datasource,
                $db_username,
                $db_password,
        {
                PrintError => 1,
                RaiseError => 1,
                AutoCommit => 0,
        }
        );

        $dbh->{LongReadLen} = 100000000;
        $dbh->{LongTruncOk} = 0;

my $func;
my $receive;

my $func = $dbh->prepare(q{
BEGIN
        xml_mobile.process_xml(
                p_spr_post => :pgp,
                p_xml_post => :receive

        );
END;});

$func->bind_param(':pgp', 'dfdfddf');

$func->bind_param_inout(':receive', \$receive,100);

$func->execute;
print $receive;

Maarten Stolte