Guyz,
I have spent several days trying to do this but have not been successful.I need to call an Oracle stored procedure from my
java code.
My stored procedure looks like this :-
create or replace
PROCEDURE GET_GROUP_DATA(P_CURSOR OUT sys_refcursor) AS
L_CATEGORY VARCHAR2(250);
L_GOAL NUMBER;
L_MONTH_TO_DATE NUMBER;
L_STATUS VARCHAR2(50);
BEGIN
OPEN P_CURSOR for
SELECT
T1.CATEGORY
, T1.GOAL
, T1.MONTH_TO_DATE
,T1.status
from T1 ;
end get_group_data;
Here is my Java code :-
Here is the error that I get - java.sql.SQLException: ORA-06553: PL**S*(ignore all *)-306: wrong number or types of arguments in call to 'GET_GROUP_DATA'.
The error message does not have * - but Javaranch thinks I am using abbreviation for PLEASE - so I had to put in * in the middle.
Please help me guyz.Thanks!