SELECT passwd,user_type
INTO :gs_pwd,:ls_type
FROM users
WHERE user_id=:ls_name;