Hi all,
I have a stored procedure that returns an array. Here is the PROC
definition:
TYPE tab_num10 is TABLE of
NUMBER(10)
INDEX BY BINARY_INTEGER;
--
--
PROCEDURE Add_Device(
p_IPAddress in varchar2,
p_DeviceType in varchar2,
p_DeviceID OUT Device_Management.tab_num10);
I have tried the standard bind_param_inout as I did before, but this
does not seem to work:
my $idx;
my $sql="BEGIN Add_Device('10.121.23.242','cisco 2600', :p_DeviceID);
END;";
$sth = $$dbh->prepare(q{$sql});
$sth->bind_param_inout(':p_DeviceID',\$idx, 10);
$sth->execute();
The error I get is as follows:
Can't bind unknown placeholder 'p_DeviceID' ('p_DeviceID') at .....
I'm running DBI v. 1.21 and DBD::Oracle v. 1.12, Oracle 9.2.0.1.0
Any help would be greatly appreciated.
Tx.
H
--
Hamish Whittal <[EMAIL PROTECTED]>
QED Technologies cc
