Details
-
Technical task
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
None
-
None
Description
Create an ORACLE PACKAGE "DBMS_OUTPUT" that contains the PUT_LINE stored
procedure.
The procedure should take one string argument that should be shown to the users using the command line client (when he has warnings enabled).
We could reuse some of the code for SIGNAL for this task.
Suggested solution:
In addition to implementing the DBMS_OUTPUT.put_line() stored procedure, we also have to implement the functionality for users to generate messages he can view in the command line client.
This is apparently something that some developers uses' everywhere' and we should try to keep the syntax simple. Signal can do part of this, but the syntax is a bit to complex for something that is used over and over again.
[MSG|MESSAGE ] "hello";
This should generate a warning of level 'message' and code 0.
The user would get this in the output in the mariadb client by enable 'warnings', which print out all warnings at the end of each statement.
We could potentially also implement 'show messages' to just show messages.
If we do that, we could add an option to 'mariadb' client to print messages at end of a query.
Attachments
Issue Links
- is part of
-
MDEV-19149 System package SYS.DBMS_OUTPUT
-
- Open
-
-
MDEV-35973 Oracle Compatibility Project 1 for 2025
-
- In Progress
-