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
Solved
custom menu using more than 4000 characters
Best answer by anmise
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.
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.
+31As 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.
+9Or you can write pieces of the code in a event action and Call the event code with the custom menu.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.