I am calling a stored package procedure which returns
REFCursor (i am using oracle version 8.1.6) through
am importing the Oracle JDBC drivers which support
bind variables of type REFCURSOR.(classes from the
oracle.jdbc.driver package(driver 8.1.7)
Used the getCursor method of the CallableStatement to
convert a REFCURSOR value returned by a PL/SQL block
into a ResultSet.
Casting the corresponding CallableStatement to
oracle.jdbc.driver.OracleCallableStatement to use the
The problem is this works absolutely fine if i connect
as the owner of the package procedure. but if i create
a public syonym for the same package and grant execute
on package to other user.
And now if i connect as this other user through jdbc
and run the same program it gives me SQLException
ora-00942 table or view does not exit.
(and the same thing works fine from sql*plus when the
package is tested from thsi other) just to inorm you
that no grants / rights issues over here.
I am just unable to understand how do i proceed in
this case, as no way i can have the package procedure
being created in the same user, also doesn't sound
implementable in live environment. Please help me.
I hope i have given required info to get an answer.
Can any body confirm is it a bug in jdbc driver 8.1.7