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.
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.
Rajeesh MenothPosted May 13, 2016, 5:04 AM
Bhuvanesh MohankumarPosted May 13, 2016, 5:40 AM
When you get the value from front end, are you convertingthe valuesto the proper data type that is required by the oracle back end.
Posted May 13, 2016, 5:32 AM
ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments
Bhuvanesh MohankumarPosted May 13, 2016, 5:13 AM
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.