Home » Developer & Programmer » Precompilers, OCI & OCCI » Program hang or crashed after executing some sql commands
Program hang or crashed after executing some sql commands [message #172357] Tue, 16 May 2006 03:19
sandodo
Messages: 1
Registered: May 2006
Junior Member
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

Previous Topic: Undefined Symbol Error
Next Topic: Embedded PlSql blocks from Pro*C to retrieve data from Multiple databases without DB Links
Goto Forum:
  


Current Time: Mon Jul 04 19:43:53 CDT 2022