1. 

   JimTer, Member

   Is there a maximum of characters a query kan handle?
   For totally unknown reasons a procedure does not work anymore when i succeed the 97595 characters (and 2379 lines).
2. 

   myDBR Team, Key Master

   No limitations other than what the database / configuration might impose.

   What is the database you are using and what characters / lines are you referring to? SQL code, report output or what?

   --
   myDBR Team
3. 

   JimTer, Member

   Im talking about a stored procedure, in which the SQL-code contains 97595 characters (and 2379 lines).
4. 

   myDBR Team, Key Master

   Without knowing the content of your report, it sounds like a *very long* report. You may want to see if you can break it up into smaller pieces.

   As for myDBR, there are no limitations to procedure. You can check if your procedure works just by executing it from the database.

   --
   myDBR Team
5. 

   JimTer, Member

   Thank you.
   We now think it is the limitation of the editor... ;-(
6. 

   myDBR Team, Key Master

   We would highly recommend breaking up the procedure to more manageable entireties. Having a single procedure with 2379 lines sounds bit adventurous.

   Try to see if you have logical blocks there or if there is something you can reuse. You can use other procedures and functions to do all this.

   --
   myDBR Team
7. 

   JimTer, Member

   Thank you.

Reply

You must log in to post.