I'm going to give this board another try...
Can anyone figure this out? I'm on OD 6.0.1 w/ the DD module on a Windows platform. The following chunk in my log file makes no sense to me. Keep in mind that I'm inserting to Oracle.
DAS:
insert into PROCESS_ACTIVITY_INSTANCE (PROC_DEF_ID, INSTANCE_ID, WORK_ITEM_ID, PROCESS_ACTIVITY_ID,
PROC_ACT_OCC_ID, USER_ID, IN_DATE, RECEIVE_DESCRIPTION, STATE, FROM_PROC_DEF_ID, FROM_PROCESS_ACTIVITY_ID,
FROM_PROC_ACT_OCC_ID, FROM_USER, PRIORITY) values
(2082, 50044, 10047, 2332, 2130, 'A', sysdate, 'F3', 'active', 2082,
2332, 2130, 'WEBGUEST', 0)
DAS:ERROR
QLException: ORA-00900: invalid SQL statement
DAS:ERROR:Vendor error code: 900
DAS:ERRORQL state: 42000
DAS:TUPLE={}
DAS:ERRORQLException: ORA-01009: missing mandatory parameter
So, the funny thing is that
Oracle is just fine with that query, copied and pasted. So, what is DAS injecting to screw with my query? Further, the logged message is garbage since it's not invalid SQL since Oracle likes it.
Dave
Current Environments:
(1,2) TS 6.5 on W2K3
(3) Vignette V7 Portal on Solaris 9
