PLSQLCOP-395: class ".OperationCanceledException"'s signer information does not match signer information of other classes in the same package.This grammar change is only relevant to those customers that are using db* CODECOP as a library or write own validators.A LabelStatement is now always part of a PlsqlBlock and not a standalone statement anymore. This affects existing PlsqlBlock in a Body.A PlsqlBlock starts now with an optional LabelStatement.PLSQLCOP-397: Parse error with anonymous PL/SQL block starting with a label.G-7130: False positive when using locally defined types.PLSQLCOP-350: G-9030: Try to define a default value on conversion errors.PLSQLCOP-349: G-9020: Try to use a format model and NLS_NUMERIC_CHARACTERS in string to number conversion functions.PLSQLCOP-348: G-9010: Always use a format model in string to date/time conversion functions.PLSQLCOP-347: G-7730: Avoid multiple DML events per trigger if primary key is assigned in trigger.
#Plsql plus editor for mac update#
PLSQLCOP-346: G-7720: Never use multiple UPDATE OF in trigger event clause. PLSQLCOP-345: G-7330: Always assign values to OUT parameters. PLSQLCOP-344: G-7250: Never use RETURN in package initialization block. PLSQLCOP-343: G-7125: Always use CREATE OR REPLACE instead of CREATE alone. PLSQLCOP-342: G-5080: Always use FORMAT_ERROR_BACKTRACE when using FORMAT_ERROR_STACK or SQLERRM. PLSQLCOP-341: G-4325: Never reuse labels in inner scopes. PLSQLCOP-340: G-4270: Avoid comparing boolean values to boolean literals. PLSQLCOP-339: G-4260: Avoid inverting boolean conditions with NOT. PLSQLCOP-338: G-4250: Avoid using identical conditions in different branches of the same IF or CASE statement. PLSQLCOP-337: G-3320: Try to move transactions within a non-cursor loop into procedures. PLSQLCOP-336: G-3310: Never commit within a cursor loop. PLSQLCOP-335: G-3195: Always use wildcards in a LIKE clause. PLSQLCOP-334: G-3185: Never use ROWNUM at the same query level as ORDER BY. PLSQLCOP-333: G-3115: Avoid self-assigning a column. PLSQLCOP-332: G-2610: Never use self-defined weak ref cursor types. PLSQLCOP-331: G-2145: Never self-assign a variable. PLSQLCOP-330: G-2135: Avoid assigning values to local variables that are not used by a subsequent statement. PLSQLCOP-329: G-1080: Avoid using the same expression on both sides of a relational comparison operator or a logical operator. 
Providing validator checks for all guidelines introduced in PL/SQL & SQL Coding Guidelines 4.0:
0 kommentar(er)
