I try to make a Build script to compile SQL script on an Oracle DB.
The Build script work great, compile SQL on DB and show the errors of the compilation in the output panel.
Now my problem is that my SQL script is composed of multiple independent entities that are compiled separately and the line number of the errors message is relative to each entities.
It mean that an error in line 1 in entity 2 doesn't mean line 1 of the file, but first line of the entity in the file (eg. line 128).
So next_result (F4) command is useless here because it don't show the right line.
My question is:
Is there a way to overload the next_result command to give it a custom line number or a kind of hook on this command ?
I thought about others options to achieve what I want with a plugin, but the Build System work great and is exactly what I need except for the next_result/prev_result.
Thanks for your help.