#14274: Warning messages should be displayed to the user if the script is executed with warning.

abhishekj(*) reported 2016-02-11T13:22:18Z · last modified 2016-02-11T14:12:41Z

Dev	tariqrahiman
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	DB - Oracle
Version	Future

Product: Aqua Data Studio

Version: 18.0.0-dev-48

Build #: 48544

Build Date: 2016-Feb-09 04:00:23 PM

Operating Environment: Windows 8.1 (6.3, amd64) / Cp1252 / en / IN / Oracle Corporation 1.8.0_66-b18

Memory: Max=704,643,072; Total=347,602,944; Free=121,234,080; CPUs=8

Steps to reproduce the issue :

CREATE OR REPLACE PACKAGE "C##source"."aaa"

PROCEDURE add_seq(a number) IS

BEGIN

EXECUTE IMMEDIATE 'ADD SEQUENCE '||a;

END add_seq;

END my_pkg1;

Observation :

When we execute the above script it display the message " Warning: execution completed with warning".
Neither in view log,or sql log warning messages are displayed
Same behavior is observed in the previous version V17 & V16 ads builds.
We should display the warning messages to the user,so that it can help user to rectify the warnings and can correct the script accordingly.
When we compare with Sql Developer tool ,it display the warning message under compiler log.

All Comments (0) Change History