Re: ORA-01036: illegal variable name/number

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 07 Sep 2006 06:23:14 -0700
Message-ID: <1157635391.281487@bubbleator.drizzle.com>

CJM wrote:

>> Doesn't seem to do much ... means precisely what?
>>

>
> Unfortunately it means exactly what it says... I issued transactional
> commands against a database object which neither returned an error or did
> anything useful. Specifically, I couldnt rollback series of transactions; se
> my earlier thread 'OO4O Transactions: Updates not being rolled=back'.

Perhaps your driver, being Microsoft technology, is autocommitting so there is nothing to roll back.

Try this simple test.

INSERT ONE ROW
ROLLBACK;
COMMIT; Is the row committed or rolled back?

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group

Received on Thu Sep 07 2006 - 08:23:14 CDT