Loop procedures/functions in a package |
Post Reply ![]() |
Author | |
remco.goris@centric ![]() Groupie ![]() Joined: 07-February-2019 Points: 2 |
![]() ![]() ![]() ![]() ![]() 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 ![]() Admin Group ![]() Stefan Mueller Joined: 25-January-2003 Location: New Zealand Points: 1031 |
![]() ![]() ![]() ![]() ![]() |
No,
unfortunately there isn’t any such function .. currently you will have to parse
packages yourself (using the TPLSQLParser helper class). |
|
![]() |
|
GregKos ![]() Groupie ![]() Joined: 21-March-2019 Points: 1 |
![]() ![]() ![]() ![]() ![]() |
Is there a way to somehow automate the parsing of packages btw?
|
|
![]() |
|
administrator ![]() Admin Group ![]() Stefan Mueller Joined: 25-January-2003 Location: New Zealand Points: 1031 |
![]() ![]() ![]() ![]() ![]() |
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 ![]() Groupie ![]() Joined: 23-August-2019 Location: Ottawa Points: 1 |
![]() ![]() ![]() ![]() ![]() |
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 ![]() Admin Group ![]() Stefan Mueller Joined: 25-January-2003 Location: New Zealand Points: 1031 |
![]() ![]() ![]() ![]() ![]() |
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.
|
|
![]() |
Post Reply ![]() |
|
Tweet
|
Forum Jump | Forum Permissions ![]() You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |