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)=SUC
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)=SUC
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.
