DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Unhandled datatype (180) found in kzabndinf

  1. #1
    Join Date
    May 2008
    Posts
    29

    Unhandled datatype (180) found in kzabndinf

    My database udump area is getting filled up by the trace contains

    Unhandled datatype (180) found in kzabndinf
    cur=05 bnd=03 dty=180
    Unhandled datatype (180) found in kzabndinf
    cur=12 bnd=01 dty=180
    Unhandled datatype (180) found in kzabndinf
    cur=12 bnd=02 dty=180
    Unhandled datatype (180) found in kzabndinf
    cur=05 bnd=03 dty=180
    Unhandled datatype (180) found in kzabndinf
    cur=13 bnd=01 dty=180
    Unhandled datatype (180) found in kzabndinf

    1) Does anyone know what this error means?
    2) What is datatype(180)?
    3) What is kzabndinf?

    any response will be highly appreciated.

    Regards

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Its possible to create types in Oracle, and it is possible to write PL/SQL code behind the type. If you wrote a type named kzabndinf and that type is causing unhandled errors, then maybe you would get the behavior that you describe. So look in the database and find an object with the name kzabndinf and see what type of object it is and whether or not it is in an invalid state.

    I don't think that this is something native to Oracle, but with the sparse information that you give, it could be.

    http://download.oracle.com/docs/cd/B...htm#SQLRF01502

  3. #3
    Join Date
    May 2008
    Posts
    29
    Hi, I did not find any objects in dba_objects. 0 rows returned.

    Regards

  4. #4
    Join Date
    May 2008
    Posts
    29
    I have received a reply from Oracle and here it is, just wanted to share with u all

    Hi,

    this is because of auditing with binds in either Standard Auditing
    (audit_trail = DB_EXTERNAL) or Fine Grained Auditing with
    audit_trail => DBMS_FGA.DB_EXTENDED, the 'kzabndinf' is an internal
    module that is supposed to translate the bind values to a readable
    string, the problem is it does not support all datatypes,
    datatype 121 is 'DTYADT' which is some sort of object type.
    In that case it writes this message to a trace file.

    This is expected behavior, it's not a bug. It's likely that in future
    releases we'll enhance the auditing system to be able to capture
    binds of any type.

    greetings,

    Harm ten Napel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width