Print Page | Close Window

Loop procedures/functions in a package

Printed From: ORCL Toolbox
Category: ORCL Toolbox
Forum Name: FormsAPI Master
Forum Description: FormsAPI Master related questions and answers
Printed Date: 21-September-2021 at 10:42am
Software Version: Web Wiz Forums 11.01 -

Topic: Loop procedures/functions in a package
Posted By: remco.goris@centric
Subject: Loop procedures/functions in a package
Date 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)??

Posted By: administrator
Date 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).


Posted By: GregKos
Date Posted: 22-March-2019 at 5:38am
Is there a way to somehow automate the parsing of packages btw?

Posted By: administrator
Date 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. 


Posted By: DonnieWCampbell
Date 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?

Posted By: administrator
Date 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.

Print Page | Close Window

Forum Software by Web Wiz Forums® version 11.01 -
Copyright ©2001-2014 Web Wiz Ltd. -