Parameterized Oracle Packages

Parameterized Oracle Packages

Comments

  • Is there a specific syntax to call oracle package procs with parameters? Ive tried below but nothing seems to work:

    KMPROD.PACKAGE_WEB_VALIDATION_PROCS.VALIDATE_ACCTUNIT(:Entity, :Account, :TOC);
    exec KMPROD.PACKAGE_WEB_VALIDATION_PROCS.VALIDATE_ACCTUNIT(:Entity, :Account, :TOC);
    KMPROD.PACKAGE_WEB_VALIDATION_PROCS.VALIDATE_ACCTUNIT :Entity, :Account, :TOC

    Any help is appreciated.

Sign In or Register to comment.