asked on

pls-00323 Error

ERROR: Subprogram or cursor 'ORC_AspNET' is declared in specification and must be defined in the package body

Here is the code I do not see where the problems lies, please help!!!!!!

PACKAGE I_NET2 as
procedure Orc_AspNET2
(i_CuSTOMER_ORDER_ID in Varchar2, i_LINE_NO in Number , i_PART_ID in VARCHAR , i_LINE_STATUS in Char ,
i_ORDER_QTY in Number,i_USER_ORDER_QTY in Number , i_SELLING_UM in Number,
i_DESIRED_SHIP_DATE in date , i_UNIT_PRICE in number,
i_TRADE_DISC_PERCENT in Number, i_EST_FREIGHT number , i_COMMISSION_PCT in number,
i_MISC_REFERENCE in VarChar, i_PROMISE_DATE in Date,
i_ALLOCATED_QTY in Number, i_FULFILLED_QTY in Number, i_USER_1 in VarChar,
i_USER_2 in VarChar);

end I_NET2;

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

PACKAGE BODY I_NET2
as procedure Orc_AspNET2

(i_CUST_ORDER_ID in Varchar2, i_LINE_NO in Number , i_PART_ID in VARCHAR , i_LINE_STATUS in Char ,
i_ORDER_QTY in Number,i_USER_ORDER_QTY in Number , i_SELLING_UM in Number,
i_DESIRED_SHIP_DATE in Date, i_UNIT_PRICE in number,
i_TRADE_DISC_PERCENT in Number, i_EST_FREIGHT in number, i_COMMISSION_PCT in Number,
i_MISC_REFERENCE in VarChar, i_PROMISE_DATE in Date,
i_ALLOCATED_QTY in Number, i_FULFILLED_QTY in Number, i_USER_1 in VarChar, i_USER_2 in VarChar)
is

Begin
       INSERT INTO SYSADM.CUST_ORDER_LINE
(Cust_Order_ID, LINE_NO, PART_ID, LINE_STATUS,
ORDER_QTY, USER_ORDER_QTY, SELLING_UM,
DESIRED_SHIP_DATE, UNIT_PRICE, TRADE_DISC_PERCENT, EST_FREIGHT, COMMISSION_PCT,
MISC_REFERENCE, PROMISE_DATE, ALLOCATED_QTY,
FULFILLED_QTY, USER_1, USER_2)

values(i_CUST_ORDER_ID, i_LINE_NO, i_PART_ID, i_LINE_STATUS,i_ORDER_QTY, i_USER_ORDER_QTY, i_SELLING_UM,
i_DESIRED_SHIP_DATE, i_UNIT_PRICE, i_TRADE_DISC_PERCENT, i_EST_FREIGHT, i_COMMISSION_PCT,
i_MISC_REFERENCE, i_PROMISE_DATE, i_ALLOCATED_QTY,
i_FULFILLED_QTY, i_USER_1, i_USER_2);

end Orc_AspNET2;
end I_NET

paquicuba

PACKAGE I_NET2 as
procedure Orc_AspNET2
(i_CuSTOMER_ORDER_ID in Varchar2, i_LINE_NO in Number , i_PART_ID in VARCHAR , i_LINE_STATUS in Char ,
i_ORDER_QTY in Number,i_USER_ORDER_QTY in Number , i_SELLING_UM in Number,
i_DESIRED_SHIP_DATE in date , i_UNIT_PRICE in number,
i_TRADE_DISC_PERCENT in Number, i_EST_FREIGHT number , i_COMMISSION_PCT in number,
i_MISC_REFERENCE in VarChar, i_PROMISE_DATE in Date,
i_ALLOCATED_QTY in Number, i_FULFILLED_QTY in Number, i_USER_1 in VarChar,
i_USER_2 in VarChar);

End Orc_AspNET2 ;
end I_NET2;

paquicuba

Actually, I'm wrong, this part is the specification, you don't need to end it here...

paquicuba

In the specification:

i_EST_FREIGHT number

i_EST_FREIGHT IN number

paquicuba

Are you in Richmond, VA by any chance?

devlins

ASKER

NO, I in the deep south......

I made that change but I am still getting the error..

Any clue to why it would error out like that???

Thanks.......

paquicuba

The subprogram in the specification and the subprogram in the body don't match, in this case:
This is the first column in your specification
i_CUST_ORDER_ID

This is your first column in your body
i_CuSTOMER_ORDER_ID

SOLUTION

paquicuba

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

sujit_kumar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

devlins

ASKER

Thank you guys for the help it finally worked with sujit_kumar answer.....

Have a good day!!!!