I'm trying to make a very simple PL/SQL transaction w/up to 3 purchases in a single transaction in portal and I've hit a wall. If I uncomment the below illustrated code, I get errors:
Line No. 44 : PLS-00306: wrong number or types of arguments in call to '=' (WWV-17050 and
ORA-24344: success with compilation error (WWV-11230)
I've even tried ':=' where I have the >> instead... but it still doesn't work. Am I assigning wrong? Please help me out.
EDIT: I realized this is probably the wrong forum for this. I apologize in advance. Thanks
(
emp_id IN NUMBER,
cust_id IN NUMBER,
tran_paymenttype IN VARCHAR2,
inv_id_input1 IN NUMBER,
inv_id_input2 IN NUMBER,
inv_id_input3 IN NUMBER)
as
temp_transseqnum number(6);
temp_sysdate date;
--item1 number (5, 2);
--item2 number (5, 2);
--item3 number (5, 2);
--trans_total number (6, 2);
begin
select trans_id.nextval
into temp_transseqnum
from dual;
Bookmarks