using loadjava

[nidhi]

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

[bbq]

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

[nidhi]

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