Re: Creating Packages hangs... forEVer.

On 2015/08/19 16:06, David Hicken wrote:

> My issue is that when I issue a "CREATE OR REPLACE PACKAGE BODY" command, it seems to hang forever... although in reality it does finish eventually. The wait that is being shown in the DB "SQL*Net more data from client". It can take literally up to hours of waiting. I am running the .sql file from a remote client sqlplus. The actual package is about 3500 lines long, and approximately 150K in size.

I have to ask: does the SQL end with a terminating slash "/"?

Also, making sure that echo is off might also help, given the size and it's running from a remote terminal...

Just some thoughts.

Rich

--
http://www.freelists.org/webpage/oracle-l