I can compile the each procedure individually with no errors, however whenI refresh the package the body displays and X.If I compile the whole package we get 3 errors. If we recompile the bodiesthe error goes away. Error:====================
==========
==========
==========
==========
==========
==========
==========
==========
======.NET
ERROR {System.Data.OracleClient.
OracleExce
ption: ORA-04063: package body"INIT_PRICE.PRICE_LIST
_REPORTING
" has errorsORA-06508: PL/SQL: could not find program unit being called:"INIT_PRICE.PRICE_L
IST_REPORT
ING"ORA-06
512: at line 1 at System.Data.OracleClient.O
racleConne
ction.Chec
kError(Oci
ErrorHandl
eerrorHand
le, Int32 rc)at System.Data.OracleClient.O
racleComma
nd.Execute
(OciStatem
entHandles
tatementHa
ndle, CommandBehavior behavior, Boolean needRowid,OciRowidDescript
or& rowidDescriptor, ArrayList& resultParameterOrdinals)at
System.Dat
a.OracleCl
ient.Oracl
eCommand.E
xecuteNonQ
ueryIntern
al(Boolean
needRowid,
OciRowidDescriptor& rowidDescriptor)at System.Data.OracleClient.O
racleComma
nd.Execute
NonQuery()
atMicrosof
t.Practice
s.Enterpri
seLibrary.
Data.Datab
ase.DoExec
uteNonQuer
y(DbComman
dcommand)a
tMicrosoft
.Practices
.Enterpris
eLibrary.D
ata.Databa
se.Execute
NonQuery(D
bCommandco
mmand)at Cwb.InitialPriceReporting.
Form1.Mode
0_SaveInse
rtPriceLis
tHeader() inC:\SvnWork\InitialPriceR
eporting\D
otNet\Init
ialPriceRe
porting\Fo
rm1.cs:lin
e184}=====
==========
==========
==========
==========
==========
==========
==========
==========
==========
====== ORACLE SQL ERROR Error report:ORA-04063: package body "INIT_PRICE.PRICE_LIST_REP
ORTING" has errorsORA-06508: PL/SQL: could not find program unit being called:"INIT_PRICE.PRICE_L
IST_REPORT
ING"ORA-06
512: at line 6404063. 00000 - "%s has errors"*Cause: Attempt to execute a stored procedure or use a view that haserrors. For stored procedures, the problem could be syntaxerrorsor references to other, non-existent procedures. For views,the problem could be a reference in the view's defining query toa non-existent table.Can also be a table which has references to non-existent orinaccessible types.*Action: Fix the errors and/or create referenced objects as necessary. ==========================
==========
==========
==========
==========
==========
==========
==========
======
Start Free Trial