Hi,
I'm trying to bind a perl variable to an Oracle table reference with
Oracle 9.2.0.3, DBD::Proxy and Perl::DBI 1.37 without success. I
could'nt find help on this in the docs or list archives. I hope this is
the right place to post.
In SQL*Plus:
SQL> desc getReference
FUNCTION getReference RETURNS REF OF TABLETYPE
SQL> select getReference() from dual;
GETREFERENCE()
----------------------------------------------------------------------
0000280209C229D2216EF6A5F4E030010A8D086AD3C204FC6EE0E46501E030010A8D08
2CE703C0000E0000
My code:
my $ref = undef;
my $sth = $dbh->prepare('BEGIN ? := getReference(); END;');
$sth->bind_param_inout(1, \$ref, 128, SQL_REF );
$sth->execute();
yields:
PLS-00382: expression is of wrong type
Even fetching a reference does not work:
my $sth = $dbh->prepare('SELECT getReference() FROM DUAL');
$sth->execute();
($ref) = $sth->fetchrow_array();
yields undef in $ref.
I'd very much appreciate your help.
cheers,
Henrik
--
hendrik fu�
morphochem AG
gmunder str. 37-37a
81379 muenchen
tel. ++49-89-78005-0
fax ++49-89-78005-555
[EMAIL PROTECTED]
http://www.morphochem.de
