Skip to main content
Solved

Error saving CQ with Modify


Sweta Garai
Forum|alt.badge.img+1

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.

View original
Did this topic help you find an answer to your question?

Forum|alt.badge.img+5
  • New Participant
  • October 5, 2023

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.


sumek
Forum|alt.badge.img+1
  • Known Participant
  • January 4, 2024

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


john
Forum|alt.badge.img
  • Community Manager
  • January 5, 2024

sumek
Forum|alt.badge.img+1
  • Known Participant
  • January 5, 2024

I meant the difference between aliased and unaliased SELECT. One producing WAEvent, the other not


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings