I am trying to write a CQ with MODIFY statement that replaces all “Not Available” to NULL but I am getting an error “Left expression do not refer to an object”. Please refer to the screenshot for reference.

I am trying to write a CQ with MODIFY statement that replaces all “Not Available” to NULL but I am getting an error “Left expression do not refer to an object”. Please refer to the screenshot for reference.
Best answer by Sid
Modify function needs WAEvent as output stream.
SELECT * FROM OracleOutputStream;
creates a typed/user-defined event
SELECT d FROM OracleOutputStream d;
creates a WAEvent
Using * instead of an alias creates a user-defined event. Hence, there is an error in saving the component.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.