| Problems compiling a package / package body [message #163997] |
Tue, 21 March 2006 03:26  |
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
|
Senior Member |
|
|
Hi all,
we have a user package on our database.
I exported the complete DB from 8.1.7.4 and imported it into 10.1.0.4.
Afterwards one package body is invalid.
Try to recompile with
alter package xxxxxxx.xxxxxx recompile package body
will give ot that it is compiled with errors
show error will bring out "No Errors"
How could I find which error is running in ?
regards
Uwe
|
|
|
|
|
|
| Re: Problems compiling a package / package body [message #164019 is a reply to message #164007] |
Tue, 21 March 2006 06:07  |
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
|
Senior Member |
|
|
Thanks,
but the result is stil the same:
SQL> set serveroutput on;
SQL> alter package WESTREPMAN.WESTBURY compile;
Warning: Package altered with compilation errors.
SQL> show errors;
No errors.
SQL>
any other suggestions ?
|
|
|
|
|
|
|
|
|
|
| Re: Problems compiling a package / package body [message #164029 is a reply to message #164028] |
Tue, 21 March 2006 06:47 |
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
|
Senior Member |
|
|
Hi Mahesh,
this is the result :
SQL> alter package WESTREPMAN.WESTBURY compile;
Warning: Package altered with compilation errors.
SQL> select name,text from user_errors;
no rows selected
There are no errors reported
uwe
|
|
|
|
| Re: Problems compiling a package / package body [message #164030 is a reply to message #164029] |
Tue, 21 March 2006 07:07 |
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
|
Senior Member |
|
|
Stab in the dark, log in as the package owner and try to recompile, then check for errors. (Shouldn't make a diff I don't think, but you never know._ and you really should use sys other than for very high level tasks (shutdown startup etc)
Jim
|
|
|
|
|
|
| Re: Problems compiling a package / package body [message #164039 is a reply to message #163997] |
Tue, 21 March 2006 07:40 |
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
|
Senior Member |
|
|
Thanks Jim,
I just done this, and noe I have an error code.
But it looks like coding problem. So they havn't tested the switch from 8.1.7.4 to 10.1 completely
WESTBURY
PLS-00593: default value of parameter "P_TMZNAME" in body must match that of spec
kind regards
Uwe
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
