Oracle 表单 - 第 11 行第 2 列的错误 103 - 在预期的地方遇到符号USER_PASSWORD

Question

declare
    v varchar2(3);
begin 
    select 'x'
    into v
    from user_details
    where
    USER_NAME = login.USER_NAME;
'and'
    USER_PASSWORD = login.USER_PASSWORD;
    if sql%found then
        open_form('D:CREDEN SOFTMENUMAIN.FMX');
    end if;
    exception
    when no_data_found then 
    message('invalid user name or password....!');
    end;

Answer 1

请检查我审核的以下代码(虽然没有测试(，请注意，您必须添加一列而不是x(并确保变量的长度正确 3 可能很小(

declare    
    v varchar2(3);
begin 
    select 'x'
    into v
    from user_details
    where
    USER_NAME = login.USER_NAME
    and
    USER_PASSWORD = login.USER_PASSWORD;
    if v is not null then
        open_form('D:CREDEN SOFTMENUMAIN.FMX');
    end if;
    exception
    when no_data_found 
    then DBMS_OUTPUT.PUT_LINE('invalid user name or password....');
    end;