db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <knut.hat...@oracle.com>
Subject Re: using set role in a stored procedure / Error 25001
Date Thu, 22 Jul 2010 11:54:48 GMT
Thomas <Thomas.K.Hill@t-online.de> writes:

> The procedure is the first call to the data base after opening the connection, 
> so there is no transaction open/pending from outside this procedure. 
> Within the procedure itself however I need to query the catalog to see if a 
> role 
> is already set and only if this is not the case set the role as needed/
> determined by a second select.

Does it work if you call commit() on the connection after you have
queried the catalog?

Knut Anders

View raw message