Error saving CQ with Modify

Question

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.

Sid · Accepted Answer

Modify function needs WAEvent as output stream.SELECT * FROM OracleOutputStream; creates a typed/user-defined eventSELECT d FROM OracleOutputStream d; creates a WAEventUsing * instead of an alias creates a user-defined event. Hence, there is an error in saving the component.

sumek · Answer

This helped, thanks! Where could I find description of this behaviour in documentation?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded