Q
Problem solve Get help with specific problems with your technologies, process and projects.

Error when calling stored procedure

I got an error while trying to insert a record into a table using a stored procedure which includes cursor. I'm getting error as:
ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'INSERTNEWAPPLICATION' ORA-06550: line 1, column 7: PL/SQL: Statement ignored

Please send me the solution to this error.
The problem here is that your call to the stored procedure does not the right number of parameters passed to it, or the wrong type of parameters passed to it. I'll give you an example. In my database, I have a stored procedure called LAYER_SPACE. I can do a DESCRIBE on this procedure in SQL*Plus as follows:

SQL> desc layer_space
PROCEDURE layer_space
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 LAYER_OWN                      VARCHAR2                IN
 LAYER_NAM                      VARCHAR2                IN
 LAYER_TYP                      VARCHAR2                IN

If you do not have access to SQL*Plus, then query USER_ARGUMENTS instead. From the above, you can clearly see that this is a PROCEDURE. You can also see that this procedure accepts three arguments, in order from top to bottom. In my case, all three are the VARCHAR2 datatype. If any argument is not required, it will indicate this in the DEFAULT? column. Since the DEFAULT? column is blank, all three arguments are required.

Make sure that your call to your procedure is passing all required arguments and that the data you are passing is of the proper data type.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close