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

Correct syntax for invoking a packaged procedure

What is the correct syntax for invoking a packaged procedure from another procdure and passing an IN OUT record to the packaged procedure?

Note: currently "pkgname.procname(record);" is resulting in "PLS-00306: wrong number or types of arguments in call to 'procname'". Record is correctly defined in package specification.


The problem is the way you have defined dts_io_record in your test package. You should declare dts_io_record as follows:

  dts_io_record  dts_synch_pkg.dts_record;

You should be all set afterwards. With your existing codes dts_io_record has a different address (although they are identical) than the dts_io_record in the first pacakge. That is why it is generating the wrong number or types of argument error.


Dig Deeper on Using Oracle PL-SQL

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