Hi!
  I already sent message about ORA-01722 error.
  But anybody has not answered. Why?

  If NLS_TERRITORY set to territory for which a decimal separator is the comma
  (for example, CIS) and create following table and one data record
  in it:

  CREATE TABLE TEST (A NUMBER(6,2));
  INSERT INTO TEST VALUES (2.5);

  $dbh->connect(...);
  $sth->prepare('SELECT * FROM TEST');
  $sth->execute;
  @row=$sth->fetchrow_array;
  print $row[0];

  The result will be string '2,5', but not number 2.5

-- 
Best regards, Nikolay Melekhin mailto:[EMAIL PROTECTED]

Reply via email to