Menu

PLSQL -> Linking -> Across files

Support
maquejp
2012-04-23
2012-09-14
  • maquejp

    maquejp - 2012-04-23

    Hello,

    I have several Oracle PLSQL packages accross two schemas

    A function of a package invoke a function from another package.

    I can link to the "package: APP_PJ2K2" but not to a function under that
    package

    PJ2K2.PLS

    create or replace
    PACKAGE               "PKG_PJ2K2" 
    IS
    /**
     * Package: PKG_PJ2K2
     *
    ...
    create or replace
    PACKAGE BODY               "PKG_PJ2K2" 
    AS
     /**
     *  Function: PJ2K2_budget
     *
     * This function will return the budget expense (PROJECT 2012)
    ....
    

    the invoker

    create or replace
    PACKAGE "PKG_GENERAL"
    AS
    /**
     * Package: PKG_GENERAL
     *
     * 
    ...
    create or replace
    PACKAGE BODY "PKG_GENERAL" 
    AS
     /**
     *  Function: gen_get_action
     *
     * This function will return the programme action for the specific record
     *
     * Parameters:
     * - {inadonis} : NUMBER
     * - {ingrantype} : VARCHAR2
     * - {ingrantyear} : NUMBER
     *
     * Invokes:
     * - <app_grant09.pkg_pj2k2.pj2k9_get_action>
     * - <app_grant09.pkg_pj2k2.pj2k0_get_action>
     * - <app_grant09.pkg_pj2k2.pj2k1_get_action>
     * - <app_grant09.pkg_pj2k2.pj2k2_get_action>
     * - <PKG_PJ2K9> , <PKG_PJ2K0> , <PKG_PJ2K1> , <PKG_PJ2K2>
     * - <PKG_PJ2K2.pj2k2_get_action>
     * - <PKG_PJ2K2->pj2k2_get_action>
     * - <PKG_PJ2K2::pj2k2_get_action>
     *  
     * Return:
     * - VARCHAR2
     */
    FUNCTION GEN_GET_ACTION
    ...
    

    Under the invokes group only the

     * - <PKG_PJ2K9> , <PKG_PJ2K0> , <PKG_PJ2K1> , <PKG_PJ2K2>
    

    Are turned in link correctly, any other notation are not interpreted. I would
    like of course something like this working:

    * - <PKG_PJ2K2.pj2k2_get_action
    

    That would link to

    grant09/PKG_PJ2K2-pls.html#PKG_PJ2K2.PJ2K2_get_action
    

    Note that the two PLS are located in different folder.

    How can I achieve that?

    Thank you

     
  • Greg Valure

    Greg Valure - 2012-04-23

    Natural Docs is case sensitive because some of the languages it supports are
    as well. SQL is not but you'll have to treat it as if it is during linking. So
    if you defined PJ2K2_budget under PKG_PJ2K2, you'll have to link to it with
    <pkg_pj2k2.pj2k2_budget>, not <pkg_pj2k2.pj2k2_budget>.</pkg_pj2k2.pj2k2_budget></pkg_pj2k2.pj2k2_budget>

     
  • maquejp

    maquejp - 2012-04-24

    Great thank you!

     

Log in to post a comment.