Static analysis of pl/sql objects and sql queries

A system comprising:

• a processor;
• and
• a memory coupled with and readable by the processor and storing a set of instructions which, when executed by the processor, causes the processor to perform static analysis of one or more query expressions embedded in programming language source code by:
• 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.

A computer-readable memory storing a set of instructions which, when executed by a processor, causes the processor to perform static analysis of one or more query expressions embedded in programming language source code by:

• 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.