Hi,
I have 9i on Linux Red Hat 2.4.9. A package is
invalid after compiling. I did a show errors but
nothing shows. How do I see where the error is ??
SQL alter package prv_admin compile;
Warning: Package altered with compilation errors.
SQL show errors;
No errors.
Thank you in advance!
show errors package prv_admin;
show errors package body prv_admin;
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 1:23 PM
Hi,
I have 9i on Linux Red Hat 2.4.9. A package is
Janet,
try compiling the package body and then checking for errors.
alter package body prv_admin compile;
show errors;
bet you a dollar the package body has errors, not the package spec.
hope this helps.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent:
[EMAIL PROTECTED] To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
hoo.com cc:
Sent by: Subject: show errors doesn't
Title: RE: show errors doesn't show anything ???
try show errors package or
show errors package prv_admin
from the 9.2.0 SQL PLUS Reference Manual
When you specify SHOW ERRORS with no arguments, SQL*Plus
shows compilation errors for the most recently created or altered stored
procedure
Title: RE: show errors doesn't show anything ???
select *
from user_errors
where name = 'PRV_ADMIN'
/
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having
Title: RE: show errors doesn't show anything ???
-Original Message-
From: Janet Linsy [mailto:[EMAIL PROTECTED]]
I have 9i on Linux Red Hat 2.4.9. A package is
invalid after compiling. I did a show errors but
nothing shows. How do I see where the error is ??
SQL alter
Hi Janet,
Try using 'show errors package package_name' or
'show errors package body package_name'
ex. -
SQL show errors package body DBMS_ASYNCRPC_PUSH
Errors for PACKAGE BODY DBMS_ASYNCRPC_PUSH:
LINE/COL ERROR
-
103/27