Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Transpiler: Implement ReplaceDbmsOutputPutLine rule #89

Open
KieranKaelin opened this issue May 31, 2023 · 0 comments
Open

Transpiler: Implement ReplaceDbmsOutputPutLine rule #89

KieranKaelin opened this issue May 31, 2023 · 0 comments
Labels
enhancement New feature or request transpiler Transpiling of Oracle PL/SQL to PL/pgSQL code

Comments

@KieranKaelin
Copy link
Contributor

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.

@KieranKaelin KieranKaelin added enhancement New feature or request transpiler Transpiling of Oracle PL/SQL to PL/pgSQL code labels May 31, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request transpiler Transpiling of Oracle PL/SQL to PL/pgSQL code
Projects
None yet
Development

No branches or pull requests

1 participant