I have been scratching my head for a while on this one, and Google hasn't helped (the shock of this alone has floored me!)

I am using Oracle with DBI to call a stored procedure, but I need to pass a cursor as a parameter:

my $cursor;
$sth = $dbh->prepare(q{BEGIN myproc(:param, :cursor); END;});
$sth->bind_param(":param", 'my param');
$sth->bind_param_inout(":cursor", \$cursor, 32);
[download]

This doesn't work, as $cursor is nothing. I have looked at various docs and although in/out paramters are well covered, I can't find anything to tell me how to use cursors!

Cheers!

Craig