error occurred at recursive SQL level 1

Posted on 2006-04-07
Last Modified: 2012-08-14
hello there,

i am working with java and oracle 10g database.first i did a simple test to connect to the database with java and also quered the DB without      when i take values from the user to save in the DB i get an error saying
Connection not done Exception java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified.

Question by:zolf
    LVL 142

    Assisted Solution

    by:Guy Hengel [angelIII / a3]

    Author Comment


    i have gone through those sites but were not helpful to solve my problem
    LVL 17

    Accepted Solution

    basically you can look at the following:-

    1. the driver that you use. You'll have to double check whether it supports the version of the database.
    2. You need to check whether the data that you insert into, the table does it have any triggers?
    3. Just do the insert/update that you'r trying to do from JDBC directly and see whether it works.
    LVL 47

    Assisted Solution

    This is the typical 10g trap.

    Go to the remote 10g installation.
    In ...\network\admin open listener.ora


      (SID_LIST =
        (SID_DESC =
          (SID_NAME = PLSExtProc)
          (ORACLE_HOME = D:\Ora10g)
          (PROGRAM = extproc)
        (SID_DESC =
          (SID_NAME = test)
          (ORACLE_HOME = D:\Ora10g)

    Add the entry
        (SID_DESC =
          (SID_NAME = test)
          (ORACLE_HOME = D:\Ora10g)
    with regard to the particular Oracle Home and SID Name.

    Restart the listener:
    c:>lsnrctl stop
    c:>lsnctl start

    Thats all.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now