Thanks for your suggestions,
I will definitely check emacs OACS mode,
From what I understand OACS will help me extract and build proper XQL files, and execute SQL queries, but from what I have read on Barts' website about OACS mode I don't see however how OACS mode helps in writing ad_procs and/or tcl/adp pages.
The emphasis there is on building xql files and executing sql queries, but I don't consider this to be of my concern.
For everything regarding database I use Tora (Open toolkit for Oracle) http://www.globecom.se/tora/ which covers all my database needs(linux version is free), I test my sql code there and then knowing it works I copy it into xql or tcl file.
The problem that I constantly encounter is building ad_procs and tcl/adp pairs from scratch.
Ideally I would like to see something like an editor with a tcl debugger that would recognize oacs and ns calls.
I was thinking maybe having oacs procs written as a tcl package and using a tcl debugger with adding 'package require <oacs-package-name>' in tcl pages, but I have never actually tried.