I Really don't see any Trouble using even Ltrim/Rtrim
Here is Example
SQL> desc t1
Name Null? Type
----------------------------------------- -------- ----------------------------
EMPNO NUMBER(4)
ENAME VARCHAR2(10)
JOB VARCHAR2(12)

SQL> desc t2
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER
NAME CHAR(15)
TITLE VARCHAR2(15)

SQL> select a.empno, b.title
2 from t1 a, t2 b
3 where a.ename = rtrim(ltrim(b.name));

EMPNO TITLE
========= ===============
8062 CLERK
8063 CLERK
8066 SALESMAN
8066 SALESMAN
8066 SALESMAN
8066 SALESMAN
8064 SALESMAN
8065 MANAGER
8712 DBA
1212 Manager
8061 SALESMAN
8061 SALESMAN
8061 SALESMAN
8061 SALESMAN

Can you please send me the Code, There could be a problem in code.

Have you Tried just in SQL... If it works in SQL it should also work in PL/SQL

Thanks..