Q

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.


This was first published in October 2004

Dig deeper on Using Oracle PL-SQL

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close