Error 49 bad bind variable oracle forms
Posted
by
mysticfalls
on Stack Overflow
See other posts from Stack Overflow
or by mysticfalls
Published on 2012-07-05T03:39:57Z
Indexed on
2014/06/07
3:27 UTC
Read the original article
Hit count: 119
I would like to ask regarding this error...
Error 49 at line 5, column 6
bad bind variable 'S_ORD.payment_type'
Here is the code:
DECLARE
N NUMBER;
v_credit S_CUSTOMER.credit_rating%type;
BEGIN
IF :S_ORD.payment_type = 'CREDIT' THEN
SELECT credit_rating
INTO v_credit
FROM S_CUSTOMER
WHERE :S_ORD.customer_id = id;
IF v_credit NOT IN ('GOOD', 'EXCELLENT') THEN
:S_ORD.payment_type:= 'CASH';
n:=SHOW_ALERT('Payment_Type_Alert');
END IF;
END IF;
END;
I'm new to oracle forms so I'm not sure if I have a missing setup or anything. S_ORD table exist and has a column payment_type, which consists of 'CREDIT' and 'CASH' value. Thank you.
© Stack Overflow or respective owner