Hello,
I was calling a stored package procedure which was returning REFCursor (i am using oracle 8i as backend) through
jdbc and
was importing the Oracle JDBC drivers which support bind variables of type REFCURSOR.(classes from the oracle.jdbc.driver package)
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 getCursor method.
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 execute privilege granted user through jdbc and run the same program it gives me SQLException ora-09542 table or view does not exit.
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 doesn't sound implementable in live environment.
I am using jdk1.3.
Please help me. I hope i have given required info to get an answer.
Thanks.
Geeta