OraFAQ Forum: SQL & PL/SQL » SP2-0809: Warning: Package Body created with compilation errors.

Home » SQL & PL/SQL » SQL & PL/SQL » SP2-0809: Warning: Package Body created with compilation errors. (Oracle 11g, 11.2.0.3.0, Unix)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SP2-0809: Warning: Package Body created with compilation errors. [message #592308]

Tue, 06 August 2013 07:45

amit.pandey
Messages: 64
Registered: August 2006
Location: Bangalore, India

Member

Hello Everyone,

I've compiled a package with warnings ON.
Getting message SP2-0809: Package Body Created with Compilation Errors.
When I checked the errors by issuing "Show Errors", it shows "No error".

SQL> ALTER PACKAGE PKG_ABC COMPILE PLSQL_WARNINGS = 'ENABLE:ALL';

SP2-0809: Package Body Created with Compilation Errors

SQL> SHOW ERRORS

No Errors

Can anyone please tell me how to check errors for that, or oracle simply pointing that package might have performance issue.
Any help will be much appreciated.

Thanks
Amit P

Report message to a moderator

Re: SP2-0809: Warning: Package Body created with compilation errors. [message #592309 is a reply to message #592308]

Tue, 06 August 2013 08:06

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SELECT * FROM ALL_ERRORS;

Report message to a moderator

Re: SP2-0809: Warning: Package Body created with compilation errors. [message #592318 is a reply to message #592309]

Tue, 06 August 2013 08:58

amit.pandey
Messages: 64
Registered: August 2006
Location: Bangalore, India

Member

Thanks BlackSwan.
Yeah that table contains all the errors but unfortunately no rows for the package "PKG_ABC" I compiled.

Whether Oracle catch and stores the warnings related to performance also.

Regards
Amit P

Report message to a moderator

Re: SP2-0809: Warning: Package Body created with compilation errors. [message #592319 is a reply to message #592318]

Tue, 06 August 2013 09:03

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

how can we reproduce what you report?

Report message to a moderator

Re: SP2-0809: Warning: Package Body created with compilation errors. [message #592325 is a reply to message #592308]

Tue, 06 August 2013 09:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

[oracle@localhost ~]$ oerr sp2 809
00809, 0, "Package altered with compilation warnings"
// *Cause:  The PL/SQL package has been altered, but has one or more
//          warnings, informational messages or performance messages
//          that may help you to improve your PL/SQL package.
// *Action: Use the SQL*Plus SHOW ERR[ORS] command to display
//          the warnings and messages.

which USER owns the code?
which USER is trying to compile the code?

[Updated on: Tue, 06 August 2013 09:39]

Report message to a moderator

Re: SP2-0809: Warning: Package Body created with compilation errors. [message #592326 is a reply to message #592308]

Tue, 06 August 2013 09:47

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Quote:

or oracle simply pointing that package might have performance issue.

Quote:

What has performance to do with the compilation error at this stage?

Oracle PL/SQL can warn about performance related issues (such as plw-07202)
see psoug

Report message to a moderator

Re: SP2-0809: Warning: Package Body created with compilation errors. [message #592368 is a reply to message #592326]

Wed, 07 August 2013 03:43

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

PLW-07205: SIMPLE_INTEGER is mixed with BINARY_INTEGER or PLS_INTEGER
 MANUAL: PL/SQL
 INDEX:
 RELEASE:  11.0.0
 CAUSE:  Using SIMPLE_INTEGER and BINARY_INTEGER or PLS_INTEGER arguments
         in the same arithmetic expression may inhibit certain optimizations.
 ACTION: Try using SIMPLE_INTEGER values only if the expression is
         computed on a performance critical path.

Report message to a moderator

Previous Topic:	How to Search a string in the TEXT column of dba_views
Next Topic:	Commit in trigger in oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 16 08:20:22 CDT 2024