DBMS_OUTPUT Messages
System Administrators can elect to have DBMS_OUTPUT messages written to a separate worksheet while they are designing and testing their Templates that are either Table or Procedure based.
This is particularly useful as there is no requirement to log into a separate SQL development application.
To enable DBMS_OUPUT messages click the 'Toggle DBMS output’ icon from the 'Application Interface Wizard - Setup' ribbon.
When you upload your data a new worksheet will be automatically created similar to the image below:
The worksheet name will be DBMS_OUTPUT appended to the template name.
DBMS_OUTPUT messages are written into column 'O' of the worksheet.
The SQL Statement is also displayed in column 'B' for your information.
The 'Copy PL/SQL to Clipboard' button in the worksheet allows for a simple copy of the entire Wizard call to the database to be pasted into your SQL Development tool should this be required for debugging purposes.
When you have completed debugging your Template click the 'DBMS output option’ icon again from the 'Setup' ribbon to turn off the debugging.
Note - This sheet can be deleted when development is complete. Each time DBMS_OUTPUT is enabled it will be regenerated.
DBMS_OUTPUT information is only displayed for the last record in multiple row uploads.
DBMS_OUTPUT information is not available for 'Attachment' Templates.