Execute Immediate

I am using the Execute Immediate statement on Oracle 8i and when I try to execute a simply update statement in the form of

update <table> set <columm> = ... + :1, <column2> = ... + :2 where id = ...

and then use the following syntax

execute immediate sqlstatement using value1, value2;

The whole database crashed. My pl/sql tool tells me that Oracle is not connected and won't let me reconnect (gives tns listener not found) and requires that I restart the database.

Has anyone else ran into this problem?

Thanks,

--
Ashton Hobbs
ashton_at_thehobbs.com
MCSE+I, MCSD, MCDBA
(Working On OCDBA, a traitor...I know)


Sent via Deja.com http://www.deja.com/
Before you buy.