Skip to content

Transpiler: Implement ReplaceDbmsOutputPutLine rule #89

Open
@KieranKaelin

Description

@KieranKaelin

Oracle provides the DBMS_OUTPUT.PUT_LINE procedure, allowing users to write a line to the buffer.

Goal

Implement the new CYAR rule that transpiles DBMS_OUTPUT.PUT_LINE usages with RAISE NOTICE.

Example

-- Oracle
DBMS_OUTPUT.PUT_LINE('foo');
DBMS_OUTPUT.PUT_LINE(rpad('Product Name', 51) || 'Demand Status');
-- PostgreSQL
RAISE NOTICE '%', 'foo';
RAISE NOTICE '%', rpad('Product Name', 51) || 'Demand Status';

How to demo

At least one Rust unit test exists demo-ing the rule functionality.

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or requesttranspilerTranspiling of Oracle PL/SQL to PL/pgSQL code

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions