Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-01-2025 05:46 AM
What's worked for us is to use a string variable to construct the query and then use EXECUTE IMMEDIATE to execute the query:
DECLARE OR REPLACE VAR QUERY;
SET VAR QUERY = 'SELECT * FROM TABLE_CHANGES("catalog.schema.table", "' || timestamp_start || '" , "' || timestamp_end || '")';
EXECUTE IMMEDIATE QUERYYou can also put it in begin/end compound statement as well.