Tahoe
05-28-01, 22:11
| Hi everyone, I am trying to call a Oracle function which takes in a number of input parameters . I found out that if a parameter size was more than 32000(around 32K) than it gave the following error 'DBD:Oracle:st execute failed:ORA-01460 unimplemented or unreasonable conversion requested (DBD:exec error) at InsInventory.pl line 64, <> chunk 9'. Even though i am binding each parameter , the DBI documentation states that the driver understands only string and number binding . Or is there a 'long' binding which i am not aware of? Also setting of $dbh->{LongReadLen} = to a very large number is basically meant for reading data ( ie a select ) . Or does this effect insertion of long data too? Has anyone else faced problems inserting very large values through Perl calling Oracle functions/stored procs ? Following is a part of my code ... my $sth = $dbh->prepare( "declare rt number; begin rt := sinsinventory (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?); end;"); $sth->bind_param(1,$value,SQL_VARCHAR); $sth->execute(); Thanks in advance for any help .... |