Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PLS-00593: error in one of our Package Body after upgrade to 10g from 8i

user594143May 13 2008 — edited May 13 2008
This is only INVALID objects that I have after upgrading database from 8.1.7 to 10.2.

Here is full error when try to re compile: PLS-00593: default value of parameter "ISNEW" in body must match that of spec

PROCEDURE P_PutRowList(inRec In mtemain_view%RowType, isNew In Boolean DEFAULT TRUE) Is
BEGIN
IF isNew THEN
newCount#:=newCount# + 1;
newList(newCount#).MTE_JOB_ID :=inRec.MTE_JOB_ID;
newList(newCount#).MTE_TNAME :=inRec.MTE_TNAME;
dbms_output.put_line('you got here new');
ELSE
oldCount#:=oldCount# + 1;
newList(newCount#).MTE_JOB_ID :=inRec.MTE_JOB_ID;
newList(newCount#).MTE_TNAME :=inRec.MTE_TNAME;
dbms_output.put_line('you got here old');
END IF;
END P_PutRowList;


Any suggestions?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 10 2008
Added on May 13 2008
5 comments
2,721 views