Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | App - Server Registration |
| Version | 14.0 |
A new option to Set dbms_output.enable() for Oracle in Server Properties -> Advanced ->
This should be similar to the GUI element we have in Options-> General -> Appearance -> Time Format, create a new option in Oracle Server Registration so the user can set the dbms_output values.
The user can enter values like 20000, 300000 etc as well as enter the value Unlimited.
This value has different options depending on the Oracle versions. For e.g. Starting with Oracle release 10g (10.2 and above), it is possible to use the following unlimited buffer settings with DBMS_OUTPUT.ENABLE (buffer_size => NULL);
Added a "DBMS_OUTPUT Buffer Size" option to the Advanced tab of the Server Registration Dialog for Oracle. It is an editable dropdown list with [Default], [Unlimited], or a user-input buffer size.
[Default] sets dbms_output.enable;
[Unlimited] sets dbms_output.enable(null);
User-input buffer size sets BEGIN dbms_output.enable(buffer_size);
If the input buffer size cannot be parsed to a number, the buffer size will default to [Default].
Jonathan, please update the Using Advanced Properties section of the Registering Oracle Server wiki page to include the new DBMS_OUTPUT Buffer Size option. We should also update the screenshot using the new build.
Jonathan, please update the Using Advanced Properties section of the Registering Oracle Server wiki page to include the new DBMS_OUTPUT Buffer Size option. We should also update the screenshot using the new build.
Verified the DBMS_OUTPUT Buffer Size functionality and now works. Need to complete version specific test cases.
Verified the DBMS_OUTPUT Buffer Size functionality and now works. Need to complete version specific test cases.
Issue #10896 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build ADS 14.0.5-5 |
| No time estimate |
Added a "DBMS_OUTPUT Buffer Size" option to the Advanced tab of the Server Registration Dialog for Oracle. It is an editable dropdown list with [Default], [Unlimited], or a user-input buffer size.
[Default] sets dbms_output.enable;
[Unlimited] sets dbms_output.enable(null);
User-input buffer size sets BEGIN dbms_output.enable(buffer_size);
If the input buffer size cannot be parsed to a number, the buffer size will default to [Default].