Categories
- All Categories
- 76 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Highlight the point an error is detected in the SQL of a data model
Description
When editing a data model especially complex ones, it is easy to introduce an error within the SQL code. The error messaging in the application does not always give meaningful responses and does not highlight where the error was encountered when it was parsed.
If an error is detected within the SQL code the application should give a more meaningful error message but more importantly highlight in the SQL where the error was encountered. I appreciate that this may still not point to the actual area of the error but in complex code it would at least be a starting point as opposed to trying to identify where the error may be in 100's of lines of SQL.
Use Case and Business Need
This would be utilised when building complex SQL and improve efficiency in the debugging of code.
Original Idea Number: 6f3ea90cbc
Comments
-
100% agreed. At least if the error message can highlight the line number, it will be easier where the error is coming from.
0 -
Would be helpful. But is still a workaround in a lousy tool for SQL access.
0