What is the correct syntax for invoking a packaged procedure from another procdure and passing an IN OUT record...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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:
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
Related Q&A from Azim Fahmi
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.