Results 1 to 2 of 2
  1. #1
    Join Date
    May 2001
    Posts
    1

    Unanswered: using DBI , unreasonable conversion error - ORA-01460

    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 ...
    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 ....

  2. #2
    Join Date
    Jun 2004
    Location
    Nowhere Near You
    Posts
    89
    SQL_LONGVARBINARY, perhaps?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •