In my .pc file, I have following codes
TRACE("Do query %s", sqlcmd);
EXEC SQL PREPARE stmt FROM :sqlcmd ;
EXEC SQL FOR :array_cursor
EXECUTE stmt USING :array_creation_date, :array_evt_timestamp, :array_event
TRACE("Done");
where sqlcmd is a string which equals
INSERT INTO ONLINE_BUFFER_B_33 (creation_date, evt_timestamp, event) VALUES ( :v1, :v2, :v3)
When I run my compiled C binary, randomly not always, in my log file, there is "Do query %s", but no "Done"
It seems my program hang or crash when it tries to insert the record into ONLINE_BUFFER. (The record can be inserted correctly by my program after I re-started it.)
Is it possible that Oracle database is locked so there is no reply from Oracle? or is it a buffer overflow (To me it is very unlikely)? Is there other possibilities?
Please help!
Thanks a lot in advance!
sandodo
[Updated on: Tue, 16 May 2006 03:20]
Report message to a moderator
] 
Blog
Search
Help
Members
Register
Login
Home
