SQL & PL/SQL

Dear all,

I have the below procedure

MEDT_KPI_PKG.GET_BALANCE(:2 , :3 , :4 , :5 , :6 )

The structure of the package.function is :

FUNCTION Get_subno_blanace (
p_CHANNEL IN VARCHAR2,
p_SUBNO IN VARCHAR2,
p_AREA IN VARCHAR2,
p_SUBSCR_TYPE IN VARCHAR2,
p_CALL_TIME IN VARCHAR2)

When I audit this session,I found the below row under sql_bind column of aud$ table.

#1(0): #2(4):MEDD #3(8):98007865' #4(1):0 #5(1):G #6(0):

and sql_text of the table aud$ has the below value

BEGIN :1 := "MEDT_KPI_PKG".GET_BALANCE(:2 ,:3 ,:4 ,:5 ,:6 ); END;



I passed the value and when I try to execute the procedure.function as below :

exec MEDT_KPI_PKG.GET_BALANCE('MEDD','98007865','0','G','0');

it is errroring :

ORA-06550: line 1, column 7:
PLS-00221: 'GET_BALANCE' is not a procedure or is undefined
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored



What could be the reason for this ?


Kai

Edited by: KaiS on Dec 25, 2010 8:29 AM