Skip to main content

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

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

  1. Create a database package with your code and just call functions/procedures
  1. Start cutting characters, i.e. remove comments, remove indentation, cut down names of params etc.
  2.  

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. 


Or you can write pieces of the code in a event action and Call the event code with the custom menu.


Reply