LOCMEMORY/Informix BLOB problem
Posted in 1998
Topics: General Discussion
Hi, I have some code which retrieves a text blob from the database and stores it in memory, however every time I try to execute the stored procedure the program crashes - I'm running Informix 7.23 on NT4.0 Server - this is a snippet of the code - has anyone any suggestions as to what might be causing this problem e.g. are there any specific settings I should be using when working with blobs etc. ====== EXEC SQL begin declare section; loc_t SQLCommBlob; EXEC SQL end declare section; SQLCommBlob.loc_loctype = LOCMEMORY; SQLCommBlob.loc_bufsize = -1; SQLCommBlob.loc_oflags = 0; SQLCommBlob.loc_mflags = 0; EXEC SQL execute procedure sp_sel_m_comm(:date) into :SQLMktComm.Headline, :SQLMktComm.DateTime, :SQLCommBlob, :SQLMktComm.Author; ========= Cheers. Ray.