1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

FRM-32086: Bind Variable :PASSWORD parse failed at <PASSWORD>.

Discussion in 'General' started by john, Nov 13, 2014.

  1. john

    john Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Zimbabwe
    Dears

    I am trying to create a login form using 11q oracle forms builder. I have a table "login" with two columns "username" and "pswd".
    I have done the following code on the smart trigger
    DECLARE
    CURSOR login_cursor IS
    SELECT userNAME,
    PSWD
    FROM login;
    username_var login.username%TYPE;
    PSWD_var login.pswd%TYPE;
    login_flag BOOLEAN := FALSE;
    BEGIN
    OPEN login_cursor;

    <<check_records>>
    LOOP
    FETCH login_cursor INTO username_var, PSWD_var;

    IF( :username = username_var
    AND :password = PSWD_var ) THEN
    --Message('You are successfully loged In');
    -- GO_BLOCK('BLOCK8.CANVAS147');
    Message('You are successfully loged In',acknowledge);

    ----- go_item('BLOCK8.t1');
    --show_view('CANVAS147');

    Message('Message Ater :Logged In',acknowledge);
    login_flag := TRUE;

    exit check_records;
    END IF;

    EXIT WHEN login_cursor%NOTFOUND;
    END LOOP;

    CLOSE login_cursor;

    IF( NOT login_flag ) THEN
    Message('INVALID LOGIN');
    END IF;

    clear_form;
    END;
    go_item('BLOCK8.t1');



    Trying to compile I get the following error

    "
    FRM-32086: Bind Variable :pASSWORD parse failed at <PASSWORD>.
    FRM-30085: Unable to adjust form for output.
    "
    May you please assist