PL/SQL (MOSC)

MOSC Banner

PLS-00306

edited May 6, 2010 9:46AM in PL/SQL (MOSC) 7 commentsAnswered
 Dear All,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center