I think I owe some appologies, if I am interpreting this trace data correctly it appears my param is longer than 4000. Evidentally the java script I borrowed from someone else isn't doing the job correctly for checking the length of my variable in my form.
>Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm >List-Post: <mailto:[EMAIL PROTECTED]> >List-Help: <mailto:[EMAIL PROTECTED]> >List-Unsubscribe: <mailto:[EMAIL PROTECTED]> >List-Subscribe: <mailto:[EMAIL PROTECTED]> >Delivered-To: mailing list [EMAIL PROTECTED] >Date: Tue, 29 Jan 2002 19:40:06 -0800 (PST) >From: Morrison Davis <[EMAIL PROTECTED]> >Subject: Re: oracle experts using bind, HELP! >To: [EMAIL PROTECTED], [EMAIL PROTECTED] >MIME-Version: 1.0 >Content-MD5: t/UDbG4Vp+LMZ23OYmwkHw== > >Here is the information Tim asked for. > > DBI::db=HASH(0x252aec) trace level set to 9 in DBI 1.15-nothread > Note: perl is running without the recommended perl -w option > -> prepare for DBD::Oracle::db (DBI::db=HASH(0x252ac8)~0x252aec 'update >REPLIES set REPLY = ?,ICON_ID = ? where REPLY_ID = ?') > dbih_setup_handle(DBI::st=HASH(0x252dec)=>DBI::st=HASH(0x252e58), >DBD::Oracle::st, 252df8, Null!) > dbih_make_com(DBI::db=HASH(0x252aec), DBD::Oracle::st, 204) > dbih_setup_attrib(DBI::st=HASH(0x252e58), Err, DBI::db=HASH(0x252aec)) >SCALAR(0x24ff04) (already defined) > dbih_setup_attrib(DBI::st=HASH(0x252e58), State, DBI::db=HASH(0x252aec)) >SCALAR(0xad30c) (already defined) > dbih_setup_attrib(DBI::st=HASH(0x252e58), Errstr, DBI::db=HASH(0x252aec)) >SCALAR(0x24ff28) (already defined) > dbih_setup_attrib(DBI::st=HASH(0x252e58), Handlers, DBI::db=HASH(0x252aec)) >ARRAY(0x2559dc) (already defined) > dbih_setup_attrib(DBI::st=HASH(0x252e58), Debug, DBI::db=HASH(0x252aec)) 9 >(already defined) > dbd_preparse scanned 3 distinct placeholders >OCIHandleAlloc(2a3620,2b979c,4,0,0)=SUCCESS >OCIStmtPrepare(33b128,2b06cc,'update REPLIES set REPLY = :p1,ICON_ID = :p2 where >REPLY_ID = :p3',65,1,0)=SUCCESS >OCIAttrGet(33b128,4,2b97a0,0,24,2b06cc)=SUCCESS > dbd_st_prepare'd sql UPDATE > dbd_describe skipped for UPDATE > <- prepare= DBI::st=HASH(0x252dec) at >/oracle/9.0.1/Apache/Apache/cgi-bin/PostToDB.pl line 172. > -> bind_param for DBD::Oracle::st (DBI::st=HASH(0x252dec)~0x252e58 1 'Add >text 123456789012345678901234567890 >1234567890123456789012345678901234567890 > >IN RapidPART 2.3 window > click on PART > >In Part Specification window > click in blank PART NAME box > type name of symbol > hit return > >Sun standard: symbol names are NOT to start with a number (74als00 => als00) > >In Logical Pin count box > type number of pins on symbol body > click on...' HASH(0x252e1c)) > bind :p1 <== 'Add text 123456789012345678901234567890 >1234567890123456789012345678901234567890 > >IN RapidPART 2.3 window > click on PART > >In Part Specification window > click in blank PART NAME box > type name of symbol > hit return > >Sun standard: symbol names are NOT to start with a number (74als00 => als00) > >In Logical Pin count box > type number of pins on symbol body > click on...' (type 0, attribs: HASH(0x252e1c)) > bind :p1 <== 'Add text 123456789012345678901234567890 >1234567890123456789012345678901234567890 > >IN RapidPART 2.3 window > click on PART > >In Part Specification window > click in blank PART NAME box > type name of symbol > hit return > >Sun standard: symbol names are NOT to start with a number (74als00 => als00) > >In Logical Pin count box > type number of pins on symbol body > click on...' (size 4047/4048/0, ptype 7, otype 1) > bind :p1 <== 'Add text 123456789012345678901234567890 >1234567890123456789012345678901234567890 > >IN RapidPART 2.3 window > click on PART > >In Part Specification window > click in blank PART NAME box > type name of symbol > hit return > >Sun standard: symbol names are NOT to start with a number (74als00 => als00) > >In Logical Pin count box > type number of pins on symbol body > click on DONE' (size 4047/4047, otype 1, indp 0) >OCIBindByName(33b128,334b14,2b06cc,":p1",3,33b7b0,4047,1,334b26,0,334b24,0,0,2) = >SUCCESS >OCIBindDynamic(33ad34,2b06cc,334af8,fefee8cc,334af8,fefeea70)=SUCCESS > bind :p1 done > <- bind_param= 1 at /oracle/9.0.1/Apache/Apache/cgi-bin/PostToDB.pl line >173. > -> bind_param for DBD::Oracle::st (DBI::st=HASH(0x252dec)~0x252e58 2 '1' >(magic-sgr:p) HASH(0x333e08)) > bind :p2 <== '1' (magic-sr:p) (type 0, attribs: HASH(0x333e08)) > bind :p2 <== '1' (size 1/2/0, ptype 7, otype 1) > bind :p2 <== '1' (size 1/1, otype 1, indp 0) >OCIBindByName(33b128,2b7f04,2b06cc,":p2",3,2c4680,1,1,2b7f16,0,2b7f14,0,0,2)=SU C >CESS >OCIBindDynamic(33acc4,2b06cc,2b7ee8,fefee8cc,2b7ee8,fefeea70)=SUCCESS > bind :p2 done > <- bind_param= 1 at /oracle/9.0.1/Apache/Apache/cgi-bin/PostToDB.pl line >174. > -> bind_param for DBD::Oracle::st (DBI::st=HASH(0x252dec)~0x252e58 3 '299' >(magic-sgr:p) HASH(0x333e08)) > bind :p3 <== '299' (magic-sr:p) (type 0, attribs: HASH(0x333e08)) > bind :p3 <== '299' (size 3/4/0, ptype 7, otype 1) > bind :p3 <== '299' (size 3/3, otype 1, indp 0) >OCIBindByName(33b128,33a3cc,2b06cc,":p3",3,2c4660,3,1,33a3de,0,33a3dc,0,0,2)=SU C >CESS >OCIBindDynamic(33ac54,2b06cc,33a3b0,fefee8cc,33a3b0,fefeea70)=SUCCESS > bind :p3 done > <- bind_param= 1 at /oracle/9.0.1/Apache/Apache/cgi-bin/PostToDB.pl line >175. > -> execute for DBD::Oracle::st (DBI::st=HASH(0x252dec)~0x252e58) > dbd_st_execute UPDATE (out0, lob0)... > dbd_phs_in ':p2' (0,0): len 1, ind 0 > dbd_phs_in ':p3' (0,0): len 3, ind 0 > dbd_phs_in ':p1' (0,0): len 4047, ind 0 >OCIStmtExecute(2b0660,33b128,2b06cc,1,0,0,0,32)=ERROR >OCIErrorGet(2b06cc,1,"<NULL>",ffbef2e4,"ORA-01461: can bind a LONG value only >for insert into a LONG column >",1024,2)=SUCCESS > OCIErrorGet after OCIStmtExecute (er1:ok): -1, 1461: ORA-01461: can bind a >LONG value only for insert into a LONG column > >OCIErrorGet(2b06cc,2,"<NULL>",ffbef2e4,"ORA-01461: can bind a LONG value only >for insert into a LONG column >",1024,2)=NO_DATA > ERROR EVENT 1461 'ORA-01461: can bind a LONG value only for insert into a >LONG column (DBD ERROR: OCIStmtExecute)' on DBI::st=HASH(0x252e58) > !! ERROR: 1461 'ORA-01461: can bind a LONG value only for insert into a LONG >column (DBD ERROR: OCIStmtExecute)' > <- execute= undef at /oracle/9.0.1/Apache/Apache/cgi-bin/PostToDB.pl line >176. >[Tue Jan 29 19:18:17 2002] adminhelp.cgi: DBD::Oracle::st execute failed: >ORA-01461: can bind a LONG value only for insert into a LONG column (DBD ERROR: >OCIStmtExecute) at /oracle/9.0.1/Apache/Apache/cgi-bin/PostToDB.pl line 176. > -> $DBI::errstr (&) FETCH from lasth=DBI::st=HASH(0x252e58) >[Tue Jan 29 19:18:17 2002] adminhelp.cgi: ORA-01461: can bind a LONG value only >for insert into a LONG column (DBD ERROR: OCIStmtExecute) at >/oracle/9.0.1/Apache/Apache/cgi-bin/PostToDB.pl line 176. > -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0x252e58)~INNER) >OCIHandleFree(33b128,4)=SUCCESS > <- DESTROY= undef during global destruction. > -> DESTROY for DBD::Oracle::db (DBI::db=HASH(0x252aec)~INNER) >OCISessionEnd(2b0660,2b06cc,2b5628,0)=SUCCESS >OCIServerDetach(2b0c00,2b06cc,0)=SUCCESS >OCIHandleFree(2b5628,9)=SUCCESS >OCIHandleFree(2b0c00,8)=SUCCESS >OCIHandleFree(2b0660,3)=SUCCESS >OCIHandleFree(2b06cc,2)=SUCCESS > <- DESTROY= undef during global destruction. > >>Date: Tue, 29 Jan 2002 23:01:11 +0000 >>From: Tim Bunce <[EMAIL PROTECTED]> >>To: Morrison Davis <[EMAIL PROTECTED]> >>Cc: [EMAIL PROTECTED] >>Subject: Re: oracle experts using bind, HELP! >>Mime-Version: 1.0 >>Content-Disposition: inline >>User-Agent: Mutt/1.2.5i >> >>On Tue, Jan 29, 2002 at 01:56:39PM -0800, Morrison Davis wrote: >>> >>> My problem is one time it works and the next time I get >>> [Tue Jan 29 13:27:08 2002] adminhelp.cgi: DBD::Oracle::st execute failed: >ORA-01461: can bind a >>> LONG value only for insert into a LONG column (DBD ERROR: OCIStmtExecute) at >>> /oracle/9.0.1/Apache/Apache/cgi-bin/PostToDB.pl line 172. >> >>I think it's a bug. >> >>Can you post the output from adding $dbh->trace(9) before the prepare. >>Please only include the part from the initial prepare through to >>the (second) execute that fails. Thanks. >> >>Tim. >
