New Posts New Posts RSS Feed - Loop procedures/functions in a package
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Loop procedures/functions in a package

 Post Reply Post Reply
Author
remco.goris@centric View Drop Down
Groupie
Groupie


Joined: 07-February-2019
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote remco.goris@centric Quote  Post ReplyReply Direct Link To This Post 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)??
Back to Top
administrator View Drop Down
Admin Group
Admin Group

Stefan Mueller

Joined: 25-January-2003
Location: New Zealand
Points: 1027
Post Options Post Options   Thanks (1) Thanks(1)   Quote administrator Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
GregKos View Drop Down
Groupie
Groupie


Joined: 21-March-2019
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote GregKos Quote  Post ReplyReply Direct Link To This Post Posted: 22-March-2019 at 5:38am
Is there a way to somehow automate the parsing of packages btw?
Back to Top
administrator View Drop Down
Admin Group
Admin Group

Stefan Mueller

Joined: 25-January-2003
Location: New Zealand
Points: 1027
Post Options Post Options   Thanks (0) Thanks(0)   Quote administrator Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
DonnieWCampbell View Drop Down
Groupie
Groupie


Joined: 23-August-2019
Location: Ottawa
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote DonnieWCampbell Quote  Post ReplyReply Direct Link To This Post 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?
Back to Top
administrator View Drop Down
Admin Group
Admin Group

Stefan Mueller

Joined: 25-January-2003
Location: New Zealand
Points: 1027
Post Options Post Options   Thanks (0) Thanks(0)   Quote administrator Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

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