Details

    • Technical task
    • Status: Open (View Workflow)
    • Critical
    • Resolution: Unresolved
    • None
    • 12.0
    • 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

          Activity

            There are no comments yet on this issue.

            People

              Unassigned Unassigned
              monty Michael Widenius
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.