Re: Inserting CLOBS into Oracle using perl

On 21 Jun 2006 07:57:37 -0700, simpsonjohnj@xxxxxxxxx wrote:

Hi everyone. I trying to write a perl script that will insert data
from a text file into Oracle. The database contains a few clob fields
which are giving me errors. I am not too familiar with insertingn LOB
fields, but from what I have seen, I need to use ora_types for when
binding the fields that are clobs. When I run the script below, I get
the ORA-01008 error that says that not all parameters are bound.

$sth->bind_param(38, @array[37]);
$sth->bind_param(49, @array[38]);
^^ spot the typo
$sth->bind_param(40, @array[39]);
--
Andy Hassall :: andy@xxxxxxxxxxx :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
.

Relevant Pages

  • Type mapping in JBoss for Oracle9i
    ... In my database there are tables containing CLOB fields. ... But when i define the CLOB mapping in that file it does not work. ... JBoss does not throw neither an exception nor error or warning. ...
    (comp.lang.java.programmer)
  • CLOB question
    ... table on different ORACLE-9i databases. ... For this purpose I fetch all fields from the table in database one ... However there are some tables with CLOB fields. ...
    (perl.dbi.users)
  • Inserting CLOBS into Oracle using perl
    ... I trying to write a perl script that will insert data ... The database contains a few clob fields ... When I run the script and skip the CLOB fields, ... my @array =; ...
    (comp.lang.perl.modules)
  • Re: Microsoft Provider for Oracle and NCLOB
    ... I am not working with Oracle, ... size for the CLOB fields? ... always works with the data in Unicode format regardless of format in a ... > I have a problem using NCLOBs with prepared statements. ...
    (microsoft.public.dotnet.framework.adonet)
  • Bizzarre Clob field problem?
    ... My table contains 10 Clob fields which hold HTML code, ... What's totally bizarre is the correct HTML is definitely going in to the ... Clob fields but on reading it comes out different - like it's been replaced ... This works perfectly on Oracle 9.2.0.1.0 running on Win 2000 but not on ...
    (comp.databases.oracle.server)