Hackers

By thread

hackers@ivorysql.org

February 2026

2 participants
2 messages

Re: How to create a PL/iSQL package

by jiaoshuntian＠highgo.com

Hi Pierre, IvorySQL provides functionality compatible with Oracle custom packages. You can check the related usage at the following URL. https://docs.ivorysql.org/en/ivorysql-doc/v5.1/7.12 If you intend to create an Oracle system package that is not yet implemented in IvorySQL, the approach can be determined based on the developer's personal ideas. You are welcome to discuss this with the community via issues or email. Additionally, the community already has implementations of several similar Oracle-compatible system packages for reference: DBMS_UTILITY:https://github.com/IvorySQL/IvorySQL/pull/1001/changes DBMS_OUTPUT:https://github.com/IvorySQL/IvorySQL/pull/998/changes Regards, JiaoShuntian

Feb. 15, 2026

How to create a PL/iSQL package

by Pierre Forstmann

hello, I would like to know what are the steps needed to create a PL/iSQL package in C. Correct me if I'm wrong but I have not found it the documentation ? Could you please detail how code should be organized: for example if I want to implement DBMS_LOCK with C code In IvorySQL , what would be main steps: - which files should be created or modified (including for tests). - other things to know ? Thanks and regards Pierre

Feb. 13, 2026