Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why must TRIM be declared??

424508Jul 16 2004 — edited Jul 19 2004
I just want to user TRIM in the where clause and get an error:

SELECT TRIM(USER_ID)
INTO :USER_ID
FROM BENUTZER
WHERE UPPER(:USER_ID) = TRIM(USER_ID);

I get this error:
"Identifier 'TRIM' must be declared"
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 16 2004
Added on Jul 16 2004
7 comments
1,081 views