SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Package with AUTHID current_user( Urgent issue)

supersenDec 10 2014 — edited Dec 11 2014

We are facing issue with java class in Session.connect() error

We are trying to FTP the file

Oracle db has 2 schemas

schema1

schema2 ( which contains package with authid currentuser) and java class to ftp the file

while we call from schema1

begin

schema2.pkg;

end;

we are getting error in java class. which is as below

com.jcraft.jsch.JSchException: java.lang.IllegalAccessException

at com.jcraft.jsch.Session.connect(Session.java:160)

at com.jcraft.jsch.Session.connect(Session.java)

at TestCon1.createConnection(TESTCON1:73)

Caused by: java.lang.IllegalAccessException

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java)

at java.lang.reflect.Constructor.newInstance(Constructor.java)

at java.lang.Class.newInstance0(Class.java)

at java.lang.Class.newInstance(Class.java)

at com.jcraft.jsch.Session.connect(Session.java:157)

... 2 more

Session closed

Please help

this is urgent

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 8 2015

Added on Dec 10 2014

12 comments

2,302 views