I used Timeste11g + Oracle 10.0.2.5 before, I created one table and the matched cachegroup:
create table test(recvtime timestamp(6), ucdata long raw);
create ASYNCHROUNOUS writethrough cache group from ds.test(recvtime timestamp(6),ucdata varbinary(4000));
I executed the SQL in Timeten: Insert into test(sysdate,'ddddddddddddddd....dddd'); (there are 3500 characters 'd')
and the record could be find in Oracle.
Today, I update my Oracle from 10g to Oracle 11R2,and execute the same SQL in Timesten,
the SQL can be execute right in Timesten ,but I can not find the record in Oracle.
By watching the tterrors.log , there is some errors about this SQL:
12:00:00 Err: REP:21272: DS: receiver.c(99020): TT5107:TT5107:Oracle(OCI) error in Insert into "DS"."TEST"("RECVTIME","UCDATA") values
(to_timestamp('2012-11-19 12:00:00.3333','SYYYY-MM-DD HH24:MI:SS.FF6'), hextoraw('dddddddddddddddddddddddddd...dddddd'))
12:00:00 Err: REP: 21272:DS: receiver.c(9020): TT5130: TT5130: Error executing the following statement in Oracle: AWT PL/SQL BLOCK WITH META DATA
-- file "bdbTb1H.c", lineno 1927, procedure "dbdbAWTPlSqlWithMetaExecDirect()"
I insert the same record into oracle by pl/sql developer directly , OK.
I change the ucdata from 3500 'd' to 2000 'd', OK. 2001 'd' the same error with 3500 'd'.
Is it mean Oracle 11R2 can support Long Raw which the length of column is bigger than 2000. Timesten11g can support too, but Timesten11g+Oracle11R2 can not. Or if I lost some parameters configuration?
Sorry for the delay in replying. Can you please provide the exact tabel definition in Oracle and the corresponding cache group definition in TimesTen. According to the documentation thsi should be supported as long as everything is properly defined. You need to map the RAW/LONG RAW column in Oracle to a VARBINARY(n) column in TimesTen where 'n' is the maximum size of data you wish to allow.
thanks Chris for your reply, I try to do the same work in another machine and degrade the version of timesten to 11.2.1, the result is good for long raw, so I think it is a bug in 11.2.2.
the exact table defination in oracle:
create table test(
ucdata long raw);
cache group in timesten:
create asy... writethrough cache group from user.test(
Edited by: user10927220 on 2012-11-27 上午4:05
My company is an second level user. And I have told the agent agency about this problem. But I dont know if they have given the exact infomation to the Oracle surport.
Edited by: user10927220 on 2012-11-27 上午7:55