Re: A couple of questions.

Steven H. wrote:
>
> Is there a limit to the size (i.e., number of lines) of a .SQL
> (PL/SQL) source code file?

I don't think there is a defined limit (but am ready to be corrected on this). However, there are practical, site-dependant limits.

When accessed, all the code for a compiled object (stored procedure, package) goes into the SGA. So if you, for example, call:

   monster_package.tiny_procedure( ... );

then the entire (compiled) code of monster_package is brought into the SGA, possible purging other objects to make room. So if you have many and/or large procedures that are only called occasionally (month-end processing, quarterly report generation) then you may want to break them out to their own packages.

You can check on the size of your packages with

  select name, code_size
  from user_object_size
  where type = 'PACKAGE BODY';

> Does anyone know of any
> good PL/SQL debuggers?

If you find one, could you let me know?

-- 
Tomm Carr
--
"Can you describe your assailant?"
"No problem, Officer.  That's exactly what I was doing when he hit me!"