FormsAPI Master - Loop procedures/functions in a package

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
URL: http://www.orcl-toolbox.com/forums/forum_posts.asp?TID=981
Printed Date: 11-December-2019 at 2:54pm
Software Version: Web Wiz Forums 11.01 - http://www.webwizforums.com

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)??

Replies:

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).

Regards,
Stefan

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.

Regards,

Stefan

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.