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
View originalI 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
View originalModify 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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.