hello,

you may know about MySQL Error Codes 1062 (ER_DUP_ENTRY) and 1053 (ER_SERVER_SHUTDOWN).

i want to find out the corresponding error codes in Oracle and MS SQL. what are they?

thanks for your quick response.

I use Oracle, but I have no idea what "ER_DUP_ENTRY" or "ER_SERVER_SHUTDOWN" might be. Also, if you were too lazy to describe those errors, I must admit that I'm too lazy to search through MySQL error database in order to give you possible corresponding error codes in Oracle.

i agree

and this was the wrong forum, too

well what you could do is write some SQL that cuases these faults, then run that SQL on an Oracle DB and trap for the Oracel error Messages. Mind you you could make this into an evolving open source project.... use the same crappy code and run it against say DB2, SQL Server or any other SQL db and report back the error messages.

sql that causes a server shutdown????

got any samples, healdem?

oooh I dunno... how about deleting all the system objects.. that might do the trick, removing all rights to all objects except for a specific userID, killing a superuser / system userid.


Hey its not my speciality... I like my servers & applcations to be available at all times, but each to their own.....

It is quite easy to cause something like this on Oracle - login as SYS and issue

DROP TABLE dual;

That'll do.

SQL Server makes this easy. Just use SHUTDOWN.

-PatP