| Subject: | Inserts/Updates to BLOB's via synonyms fails |
The problem that existed for CLOB's and BLOB's in 1.21 has been
partially fixed. The good news is that CLOB's appear to be OK.
BLOB's however appear to still be broken. Here is an extract from a
level 3 trace ...
DBI::db=HASH(0x61b8350) trace level set to 0x0/3 (DBI @
0x0/47120086204416) in DBI 1.52-ithread (pid 27618)
-> prepare for DBD::Oracle::db (DBI::db=HASH(0x61a64d0)~0x61b8350 '
INSERT
INTO sb_demo(data_b)
VALUES (:blob)
') thr#4e9b010
dbih_setup_handle(DBI::st=HASH(0x632baa0)=>DBI::st=HASH(0x632bb90),
DBD::Oracle::st, 632bba0, Null!)
dbih_make_com(DBI::db=HASH(0x61b8350), 61c0570, DBD::Oracle::st,
448, 0) thr#4e9b010
dbd_preparse scanned 1 distinct placeholders
dbd_st_prepare'd sql INSERT (pl1, auto_lob1, check_sql1)
dbd_describe skipped for INSERT
<- prepare= DBI::st=HASH(0x632baa0) at tst-utf8.plx line 191 via at
tst-utf8.plx line 239
-> bind_param for DBD::Oracle::st (DBI::st=HASH(0x632baa0)~0x632bb90
':blob' '..........�W....' (type 0 (DEFAULT (varchar)), attribs:
HASH(0x6311c40))
bind :blob as ftype 113 (SQLT_BLOB / long)
dbd_rebind_ph(): bind :blob <== '........' (in, not-utf8, csid 0->0->0,
ftype 113 (SQLT_BLOB / long), csform 0->0, maxlen 8, maxdata_size 0)
<- bind_param= 1 at tst-utf8.plx line 197 via at tst-utf8.plx line
239
-> execute for DBD::Oracle::st (DBI::st=HASH(0x632baa0)~0x632bb90)
thr#4e9b010
dbd_st_execute INSERT (out0, lob1)...
Statement Execute Mode is 0 (DEFAULT)
dbd_st_execute INSERT returned (SUCCESS, rpc1, fn3, out0)
lob refetching a synonym named=SB_DEMO for FRAMEWORK.SB_DEMO
lob refetch from table FRAMEWORK.SB_DEMO, 3 columns:
lob refetch table col 1: 'LINE_NUMBER' otype 2
lob refetch table col 2: 'TEXT' otype 1
lob refetch table col 3: 'DATA_B' otype 113
lob refetch :blob param: otype 113, matched field 'DATA_B' by
type (DATA_B "blob")
lob refetch sql: select DATA_B "blob" from DATA_B "blob" where
rowid = :rid for update
lob refetch 1 for ':blob' param: ftype 113 setup
!! ERROR: '942' 'ORA-00942: table or view does not exist (DBD ERROR:
OCIStmtExecute/LOB refetch)' (err#1)
<- execute= undef at tst-utf8.plx line 198 via at tst-utf8.plx line
239
-> HandleError on DBI::st=HASH(0x632bb90) via CODE(0x6311080)
(undef)
It appears it is attempting to use the BLOB column name for the table
name in the refetch SQL statement.
I've attached a test script that highlights the problem.
Thanks for your help.
Steve
| Subject: | blob.plx |
Message body not shown because it is not plain text.