Loop procedures/functions in a package

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Does FormsAPI Master allow for looping through all procedures and functions in a program unit of type package (body)??

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
remco.goris@centric Members Profile Find Members Posts Groupie Joined: 07-February-2019 Points: 2	Post Options Post Reply Quote remco.goris@centric Report Post Thanks(0) Quote Reply Topic: Loop procedures/functions in a package Posted: 07-February-2019 at 4:55am
	Does FormsAPI Master allow for looping through all procedures and functions in a program unit of type package (body)??

administrator Members Profile Find Members Posts Admin Group Stefan Mueller Joined: 25-January-2003 Location: New Zealand Points: 1028	Post Options Post Reply Quote administrator Report Post Thanks(1) Quote Reply Posted: 07-February-2019 at 5:23am
	No, unfortunately there isn’t any such function .. currently you will have to parse packages yourself (using the TPLSQLParser helper class). Regards, Stefan

GregKos Members Profile Find Members Posts Groupie Joined: 21-March-2019 Points: 1	Post Options Post Reply Quote GregKos Report Post Thanks(0) Quote Reply Posted: 22-March-2019 at 5:38am
	Is there a way to somehow automate the parsing of packages btw?

administrator Members Profile Find Members Posts Admin Group Stefan Mueller Joined: 25-January-2003 Location: New Zealand Points: 1028	Post Options Post Reply Quote administrator Report Post Thanks(0) Quote Reply Posted: 22-March-2019 at 7:04am
	Not for now, still the same answer, sorry ;-). This might change in V4.0 - i do have a complete fully fledged pl/sql grammar parser implemented in that new version that is using an EBNF type grammar capable of generating AST trees (that is what you need to accurately find package procs/funcs/variables/datatypes/etc) - still would need to expose it to the scripting engine but that should be doable. TPLSQLParser (which isn't actually a parser, it's a tokenizer to be correct) will have to do for now .. searching for PROCEDURE / FUNCTION keywords and then finding the name of them isn't that difficult. Regards, Stefan

DonnieWCampbell Members Profile Find Members Posts Groupie Joined: 23-August-2019 Location: Ottawa Points: 1	Post Options Post Reply Quote DonnieWCampbell Report Post Thanks(0) Quote Reply Posted: 23-August-2019 at 10:34am
	This is unrelated to looping through packages but as you've mentioned a future Version 4, I thought I would ask if you have a planned date for this release?

administrator Members Profile Find Members Posts Admin Group Stefan Mueller Joined: 25-January-2003 Location: New Zealand Points: 1028	Post Options Post Reply Quote administrator Report Post Thanks(0) Quote Reply Posted: 23-August-2019 at 7:24pm
	V4.0 should be out early next month. It's kid of finished and feature-complete (just tidying up some small things here and there, testing it and working on all other release related things to release it (updating website, changing licensing scheme, etc)). Contact me on support[at]orcl-toolbox[dot]com if you want a preview beta.