I think it would be useful if you could create small PL/SQL functions/procedures directly in FS; the reason is that I'm finding that the supporting packages for our applications are growing quite considerably and a lot of it is very small snippets of code for doing things like showing/hiding dialogs, altering visual appearance of components...etc. It would be good if this sort of code could be contained within FS itself.
The way I envisage it might work is that you would have a new node in the Misc region called something like "Code Blocks" or something, in here you could define whatever "helper" procedures and functions you need; these would all go into a default package for the application called something like XXFS_<app_name>_CODE, the procs/funcs could then be referenced by the Actions in FS. So if my application was called AUDIT and I created a procedure in FS called "enable" then I could invoke the procedure with...
Its not a major problem that you can't do this but I think it would help improve the "developer experience" slightly since for all this type of small stuff it would all be done from within FS and the supporting code outside of FS would be just for the main features/algorithms of the application.
Just a thought.
asked 12 May '13, 17:34