Results 1 to 3 of 3

Thread: using loadjava

  1. #1
    nidhi is offline Member
    Join Date
    Jun 2007
    Posts
    2
    Rep Power
    0

    Default using loadjava

    I wanted to use java class in accessing Oracle DB
    the java class compiles successfully

    but on using loadjava

    c:\Desktop>loadjava -user demo/demo@xe -grant public -resolve PasswordValidator.class
    Error while connecting with oci8 driver to xe: oracle.aurora.server.tools.loadja
    va.ToolsException: The JDBC OCI8 Driver is not installed properly, use -thin to
    try the JDBC Thin driver: t2cGetCharSet
    exiting : could not open connection

    OR

    C:\Desktop>loadjava -thin -user demo/demo@localhost:1521:xe -resolve -verbose "c:\Desktop\PasswordValidator.java"
    arguments: '-thin' '-user' 'demo/demo@tcs047056:1521:xe' '-resolve' '-verbose' '
    c:\Desktop\PasswordValidator.java'
    creating : source PasswordValidator
    loading : source PasswordValidator
    Error while creating source PasswordValidator
    ORA-06550: line 1, column 74:
    PLS-00201: identifier 'DBMS_JAVA.SET_COMPILER_OPTION' must be declared
    ORA-06550: line 1, column 74:
    PL/SQL: Statement ignored
    ORA-06550: line 1, column 230:
    PLS-00201: identifier 'NameFromLastDDL' must be declared
    ORA-06550: line 1, column 224:
    PL/SQL: Statement ignored

    The following operations failed
    source PasswordValidator: creation (createFailed)
    exiting : Failures occurred during processing

    What shud be done??Why is it not executing loadjava correctly??

    Shefali

  2. #2
    bbq
    bbq is offline Senior Member
    Join Date
    Jun 2007
    Posts
    132
    Rep Power
    0

    Default

    Shefali,
    In the first case you are trying to use the client of oracle and it seems that you don't have installed it
    In the second case the connection is valid but the data base (or the user that you use) doesn't have the permission to compile the source code that you are trying to load

    "PLS-00201: identifier 'NameFromLastDDL' must be declared"
    this tell you that NameFromLastDDL isn't declared in your data base

    please consider these links

    Loading Stored Procedures
    ORA-04043 error after applying the patches [Archive] - DBAsupport.com Forums

  3. #3
    nidhi is offline Member
    Join Date
    Jun 2007
    Posts
    2
    Rep Power
    0

    Default

    I am using oracle xe(server and client on the same machine).I hav tried quering the dba_objects but it says table or view doesnot exist.Also the dbms_java.set_compiler_option() is non functional..

    What shud b done??

    Shefali

Posting Permissions

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