Hi All,
any experience of using a custom menu (PL/SQL-block) for more than 4000 characters?
Perhaps there is someone around having some tipps and tricks to extend this limitation.
Thanks a lot!
Mattis
Best answer by anmise
View original
Userlevel 7
Hi All,
any experience of using a custom menu (PL/SQL-block) for more than 4000 characters?
Perhaps there is someone around having some tipps and tricks to extend this limitation.
Thanks a lot!
Mattis
Unfortunately that’s the limit and the only two ways I know to get around it is
- Create a database package with your code and just call functions/procedures
- Start cutting characters, i.e. remove comments, remove indentation, cut down names of params etc.
Userlevel 7
+31
As anmise has mentioned, the best way to do this without having to write unreadable code with variable names that don’t make sense and such is to create a utility database package and write a method that you can call inside the PL/SQL block of the menu item.
Userlevel 4
+9
Or you can write pieces of the code in a event action and Call the event code with the custom menu.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.