How to call a Stored procedure that is inside the PLSQL package

[javagini]

In oracle I have a PLSQL package "Calc_Lib_packg" and there is a procedure name "get_median" what should be the parameter name in the setSql() method?

setSql("Calc_Lib_packg.get_median");

or

setSql("get_median");

Actually I am getting following error in both cases ( I tried both above options-

org.springframework.jdbc.BadSqlGrammarException: CallableStatementCallback; bad SQL grammar [{call Calc_Lib_packg.get_median(?,?)}] nested exception is java.sql.SQLException: ORA-06550: line 1, column 7:PLS-00201: identifier 'Calc_Lib_packg.get_median' must be declared

[joe]

ie :

conn.setCatalog("Calc_Lib_packg");

then you should be able to call the proc

[trisberg]

Uisng "Calc_Lib_packg.get_median" should work. Are you sure you have execute privileges on the package? If the package is in a different schema you might have to add the schema name as well like "schema.Calc_Lib_packg.get_median"