Home Download Buy Blog Forum Support

Build System next_result hook

Build System next_result hook

Postby bizoo on Wed Jun 22, 2011 9:10 am

Hi,

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.
bizoo
 
Posts: 889
Joined: Wed Dec 08, 2010 6:53 am
Location: Switzerland

Return to Technical Support

Who is online

Users browsing this forum: Yahoo [Bot] and 16 guests