![]() įor the syntax of value_clause, see Oracle Database Reference. In any of the preceding ALTER statements, you set the value of PLSQL_WARNINGS with this syntax: Use an ALTER statement from " ALTER Statements" with its compiler_parameters_clause. Use the ALTER SESSION statement, described in Oracle Database SQL Language Reference. Use the ALTER SYSTEM statement, described in Oracle Database SQL Language Reference. You can set the value of PLSQL_WARNINGS for: Treat specific warnings as errors (so that those conditions must be corrected before you can compile the PL/SQL unit) Passing a VARCHAR2 value to a NUMBER column in an INSERT statementĬondition does not affect performance or correctness, but you might want to change it to make the code more maintainable.īy setting the compilation parameter PLSQL_WARNINGS, you can:Įnable and disable all warnings, one or more categories of warnings, or specific warnings Table 11-1 Compile-Time Warning Categories CategoryĬondition might cause unexpected action or wrong results.Ĭondition might cause performance problems.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |