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

PRO+

Content

Find more PRO+ content and other member only offers, here.

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close