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: 113

Filed under:
|
|
|
|

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

Related posts about sql

Related posts about forms