Re: GNADE insert problem

["Robert I. Eachus" <rieachus@comcast.net>]

Jano wrote:

> I've workaround it disconnecting from the DB after each insert. Since I 
> insert a record per minute and the db is local, it can hold that way 
> until I get into the package you have suggested.

As an aside, this problem is why I quickly get headaches mixing Ada and 
SQL.  SQL has this concept of an implicit cursor, and you have to be 
very careful that every Ada thread containing SQL maintains its own 
cursor correctly.

How you do that depends on the database, the interface language (i.e. 
whether it is compiled or embedded SQL) and what you are doing.  But 
when you have to think in SQL while working in Ada, it is very painful.

Having an explicit cusor parameter for each SQL call is neither Ada or 
pure SQL.  But when possible, it eliminates a lot of headaches.

-- 
                                           Robert I. Eachus

"The war on terror is a different kind of war, waged capture by capture, 
cell by cell, and victory by victory. Our security is assured by our 
perseverance and by our sure belief in the success of liberty." -- 
George W. Bush