PLS-00306
I get PLS-00306 when execute the store procedure. Mentioning below is my store procedure
This store procedure , i am passing the session number and getting the Available channel number to make the outgoing call from my application.
The procedure performed as per my expectation but suddenly today(11-Mar-2010) i received the error message "
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'SP_CHANUPD'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored.
KINDLY HELP THE POSSIBILITIES OF THE ERROR. ALSO DO YOU KNOW , ANY WHERE FROM ORACLE LOG I CAN SEE WHAT HAPPENED? THANK YOU.