Static analysis of PL/SQL objects and SQL queries

摘要

Embodiments of the invention provide systems and methods for performing static analysis of query expressions embedded in programming language source code. According to one embodiment, performing static analysis of one or more query expressions embedded in programming language source code can comprise extracting the one or more query expressions from the programming language source code, performing the static analysis on the extracted one or more query expressions, and reporting results of performing the static analysis on the one or more query expressions, wherein the results relate errors and warning generated by performing the static analysis to the source code from which the one or more query expressions are extracted.

主权项

1. A method for performing static analysis of one or more query expressions embedded in programming language source code, the method comprising:
extracting the one or more query expressions from the programming language source code, wherein extracting the one or more query expressions and performing the static analysis comprises reading the source code in which the one or more query expressions are embedded, parsing the source code in which the one or more query expressions are embedded, extracting query expression code for the one or more query expressions from the parsed source code, creating a procedure from the extracted query expression code, and compiling the created procedure; performing the static analysis on the extracted one or more query expressions, wherein performing the static analysis further comprises detecting a collision between triggers in the extracted one or more query expressions based on said analyzing and applying one or more user defined rules to the created procedure, the one or more user defined rules defining guidelines and conventions for the query expressions and in response to any of the extracted one or more query expressions violating the one or more user defined rules, generating an error or warning; and reporting results of performing the static analysis on the one or more query expressions, wherein the results relate errors and warning generated by performing the static analysis to the source code from which the one or more query expressions are extracted.