SQL Syntax Check
AndreasBiBi
Posts: 1 New member
in SQL Prompt
Does anyone know whether a good parser exists for a strong/strict/exact syntax check?
To check the programmed source code in procedures, functions, views.
A parser which checks e.g. the data types of the variables, the passed parameters to other procedures and functions, the used tables etc.
I faced some critical runtime faults during runtime because of some "simple" programming faults which could actually be detected by a good parser.
The SQL Prompt function "Find Invalid Objects" can find something but also not in that quality, what a modern Java or C++ compiler syntax check would detect.
To check the programmed source code in procedures, functions, views.
A parser which checks e.g. the data types of the variables, the passed parameters to other procedures and functions, the used tables etc.
I faced some critical runtime faults during runtime because of some "simple" programming faults which could actually be detected by a good parser.
The SQL Prompt function "Find Invalid Objects" can find something but also not in that quality, what a modern Java or C++ compiler syntax check would detect.
Tagged:
Answers
Is there certain SQL that your finding that the "Find Invalid Objects" is not correctly identifying?