I am getting:
Error: ORA-04030: out of process memory when trying to allocate 526592 bytes (PLS non-lib hp,PAR.Carchktb)
when trying to save changes/compile after making changes to a procedure..
I tried to reduce the sort area size int the session didn't help.

Any suggestions?