Tuesday, October 9, 2007

ORA-1401 has been discared in oracle 10g

A new error message ORA-12899 has been created instead of the dreaded ORA-01401 error message in Oracle 10g version.

What is the benefit of changing this error ?


Well while this new error message is displayed Oracle will also display the field name in which the NULL was not allowed.



"ORA-01401: Inserted value too large for column"ORA-12899: value too large for column"DB"."TABLE_NAME"."FIELD_NAME" (actual: 6, maximum:5)This was a nice enhancement.

Ask Tom Article:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::
P11_QUESTION_ID:7143933880166

2 comments:

  1. Can anyone recommend the robust Endpoint Security system for a small IT service company like mine? Does anyone use Kaseya.com or GFI.com? How do they compare to these guys I found recently: [url=http://www.n-able.com] N-able N-central support network
    [/url] ? What is your best take in cost vs performance among those three? I need a good advice please... Thanks in advance!

    ReplyDelete
  2. oZzy moved away some time ago, I miss his cock, and i
    am always hungry for sex.
    FUCK MY PUSSY!

    My weblog; hcg injections

    ReplyDelete