Ask the Expert

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.

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: