Problems with Large Packages in Oracle 7.0.15/SCO

From: Carlos Netto <Carlos.Netto_at_ax.apc.org>
Date: Fri, 12 Aug 94 23:33:00 -0300
Message-ID: <2aa.552.846%mpcbbs_at_ax.apc.org>

Hi all,

I have a large package, like this:

   PACKAGE          Proc4 -- Only this procedure can be used    

   END PACKAGE        PACKAGE BODY    

     Proc1
     
     Proc2
     
     Proc3
     
     Proc4
     

   END PACKAGE If, at any point of the code, I raise an exception, I get only te error "NO_DATA_FOUND". No the real error; nothing about the line number where it's raised. It's a problem when the exception comes of a real error, of course! I can't find it without loosing 1 hour looking for it.

With smaller packages (nothing different; only the size), Oracle shows me the line number and the correct exception raised inside the code.

Do you know anything about it? It seems to be a bug, but....

Thanks,

---

| Carlos Augusto Leite Netto | Voice : +55.192.51.1153 |
| Software Design Informatica | Fax : +55.192.54.6518 |
| Oracle VAR | e-mail : carlos.netto%mpcbbs_at_ax.apc.org |
| Software Development & DBA | FidoNet: 4:801/31 (Carlos Netto) |

|---------------------------------------------------------------------------|


|  Softex 2000 member             | Brazil, Sao Paulo state, Campinas city  |


=============================================================================

• Evaluation copy of Silver Xpress. Day # 49 --- via Silver Xpress V4.01P [NR]

  ---

Internet: Carlos.Netto_at_ax.apc.org (Carlos Netto) This message was processed by RAuucp from Merlin Systems Inc.

---

Received on Sat Aug 13 1994 - 04:33:00 CEST