Running a large PL-SQL package script
From: Krishnan N Thodla <krishnant_at_ph.com>
Date: Tue, 03 Nov 1998 10:17:43 -0500
Message-ID: <363F1E96.198F91F_at_ph.com>
Hi all,
Date: Tue, 03 Nov 1998 10:17:43 -0500
Message-ID: <363F1E96.198F91F_at_ph.com>
Hi all,
I am trying to run a large PL-SQL package in a script from the command line {plus33 -s <username>/<password>_at_alias @scriptname.sql}. The package header compiles fine, but the body compilation immediately returns. When I check using the schema manager, the body does not exist. If I do the same thing interactively with SQL*Plus, I get an OCI error 01010-Invalid OCI operation error. If I turn Suppress Non-blocking OFF, the package compilation proceeds fine. Can someone please help me with this?
Environment: Oracle NT 7.3.4.2.1 - SQL*Plus 3.3.4.0.0, PL-SQL 2.3.4.2.0
TIA
Krishnan N Thodla
Received on Tue Nov 03 1998 - 16:17:43 CET