调用包里面的变量、常量、函数、方法等需要在对象名里包含包的名字,并用“.”分隔。

    示例:调用包的函数和方法

    1. obclient> call pkg_test.sp_insert_t1('ABC');
    2. Query OK, 0 rows affected (0.32 sec)
    3. obclient> call pkg_test.sp_insert_t1('DEF');
    4. Query OK, 0 rows affected (0.01 sec)
    5. obclient> SELECT pkg_test.f_maxid_of_t1() FROM DUAL;
    6. +--------------------------+
    7. | PKG_TEST.F_MAXID_OF_T1() |
    8. +--------------------------+
    9. | 10007 |
    10. +--------------------------+
    11. 1 row in set (0.01 sec)
    12. obclient> select * from t1;
    13. +-------+------+---------------------+
    14. | ID | NAME | GMT_CREATE |
    15. +-------+------+---------------------+
    16. | 10006 | ABC | 2020-04-02 19:03:30 |
    17. | 10007 | DEF | 2020-04-02 19:03:35 |
    18. +-------+------+---------------------+
    19. 2 rows in set (0.00 sec)