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

Thread: SQL Navigator problem

  1. #1
    Join Date
    Apr 2005
    Location
    Slovakia
    Posts
    1

    Question SQL Navigator problem

    Hi,

    I have the following problem with the SQL Navigator. I am new to this tool, so I don't know, where the problem can be.

    When I try to expand node in the DB Navigator window (for example "Packages"), I get a error message in the Output window "ORA-01460: unimplemented or unreasonable conversion requested". And of course, the node doesn't expand.
    It works just for "Tables" and "Indexes" nodes. With all other nodes this problem appears.

    Does somebody know, where the problem can be ?

    I use SQL Navigator 4.3.1.460,
    database is Oracle 9.2.0.6.0 Enterprise Edition

    Thanks.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166

    Re: SQL Navigator problem

    Originally posted by Anachron
    I use SQL Navigator 4.3.1.460,
    database is Oracle 9.2.0.6.0 Enterprise Edition
    I also use SQL Navigator. My version is 4.3.2.476. Has version 4.3.1.460 ever worked with 9i? I would guess that you need to upgrade to a newer version, but I would have to check the Quest Site to see which version in compatible. Perhaps you can check their site for compatability, www.quest.com.

  3. #3
    Join Date
    Jan 2007
    Posts
    2

    Issue resolution

    Issue can be resolved by correcting the NLS settings for Oracle in your system registry.
    Steps followed -
    1. Run regedit, Registry window will appears
    2. Select HKEY_LOCAL_MACHINE
    3. Select SOFTWARE
    4. Select ORACLE
    5. Select NLS_LANG
    Type the NLS_LANG and then enter the value AMERICAN_AMERICA.UTF8
    6. Restart the computer for registry changes to take effect.

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote Originally Posted by srinigenie
    Issue can be resolved by correcting the NLS settings for Oracle in your system registry.
    Steps followed -
    1. Run regedit, Registry window will appears
    2. Select HKEY_LOCAL_MACHINE
    3. Select SOFTWARE
    4. Select ORACLE
    5. Select NLS_LANG
    Type the NLS_LANG and then enter the value AMERICAN_AMERICA.UTF8
    6. Restart the computer for registry changes to take effect.
    Your answer would have been really helpful two years ago! But thanks anyway.

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