DBAsupport.com Forums - Powered by vBulletin
Results 1 to 1 of 1

Thread: Problems with my assignments and/or variables?!

  1. #1
    Join Date
    Oct 2002
    Location
    FL
    Posts
    5

    Question Problems with my assignments and/or variables?!

    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;

    select sysdate
    into temp_sysdate
    from dual;

    insert into transaction
    (tran_id, emp_id, cust_id, tran_datetime, TRANPAYMENTTYPE)
    values
    (temp_transseqnum, emp_id, cust_id, temp_sysdate, tran_paymenttype);

    update inventory set inv_quantityinstock = inv_quantityinstock - 1
    where inv_id = inv_id_input1;

    update inventory set inv_quantityinstock = inv_quantityinstock - 1
    where inv_id = inv_id_input2;

    update inventory set inv_quantityinstock = inv_quantityinstock - 1
    where inv_id = inv_id_input3;

    --select cata_rentalprice
    --into item1
    --from catalog
    >> --where inv_id = inv_id_input1;

    --select cata_rentalprice
    --into item2
    --from catalog
    >> --where inv_id = inv_id_input2;

    --select cata_rentalprice
    --into item3
    --from catalog
    >> --where inv_id = inv_id_input3;

    --trans_total := item1 + item2 + item3;

    exception
    when others then
    htp.p('PROC_TRANS_INV: ' || sqlcode || ' ' || sqlerrm);htp.br;

    end;
    Last edited by Aus1423; 11-15-2002 at 05:00 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width