How to use bind

[Morrison Davis]

Hi ALL,

  Fairly new to DBI but have managed to get an oracle 9.0.1 
data base up and running and a web application to access it.
I use:
        my $STATEMENT2 = "Insert into REPLIES values(
reply_id.nextval,
\'$REPLY\',
\'$myform{employee_id}\',sysdate,thread_id.currval,
\'$myform{toolid}\',\'$myform{iconid}\',\'$myform{category_id}\')";

        $stmt2 = $dbh->prepare($STATEMENT2);
        $stmt2->execute() or die $DBI::errstr;
        
the problem is $REPLY can hold upto 4000 characters. And today I got my first
error string literal too long ora-1704 says to use bind variables.

How would I use bind variables to do this same command. And where is a good place
to readup on how to use DBI bind param.
  
Thanks Morry
e-mail address: [EMAIL PROTECTED]
phone: X84792/650 786-4792 fax 650 562-2143