i want to know this solution............

Question

Hello Friends.... ORA-06550: line 1 column 7: PLS-00306: wrong number or types of arguments i want to know this solution............

Rajeesh Menoth · Answer

Hi Check the following reference : https://community.oracle.com/thread/2241527?tstart=0 http://stackoverflow.com/questions/11505204/ora-06550-line-1-column-7-pls-00306-wrong-number-or-types-of-arguments http://forums.asp.net/t/366350.aspx?ORA+06550+line+1+column+7+PLS+00306+ERROR+

Bhuvanesh Mohankumar · Answer

When you get the value from front end are you convertingthe valuesto the proper data type that is required by the oracle back end. Check the following Check form frontwhat are the values you are getting and copy to a notepad execute thesame parameter values in the oracle query with those values and check if some error of mismatch of data type or parameter is there fix that in front end and convert as per required data type. Please let me know if any issues.

Subhalaxmi Dhalsingh · Answer

Backend oracle its working fine...but in frontend its not working and its showing this error:- ORA-06550: line 1 column 7: PLS-00306: wrong number or types of arguments

Bhuvanesh Mohankumar · Answer

You need to specify all the parameters while executing the procedure. Check the number of parameters expected by the procedure is supplied properly. Check the proper space is available between two values if any Check the exact type of parameter is supplied say a number [1] is supplied for a Number type of parameter than ['1'] a varchar type supplied wrongly. Check the proper size of parameter is supplied for a integer type don't supply a sample value of 123455644553 some thing very large value than its limit. Mark as answer if helpful.

i want to know this solution............

ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments