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

    Login

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top