Re: Problems reconnecting thru embedded SQL statements after a kill session is issued.

mgresham_at_vnet.ibm.com wrote:
> We are trying to reconnect to Oracle thru embedded SQL statements after
> doing an alter system kill session and appear to be having problems.
> First, I initially connect to the database by issuing the following SQL statements:
> EXEC SQL DECLARE dbname DATABASE;
> EXEC SQL CONNECT :userid IDENTIFIED BY :passwd AT dbname USING :dbstring;

===========================SNIP============================
Marie,
	Did you try doing a rollback work release?
	This is the only way that I know will get rid of your
	shadow process.
		parris geiser