Hi Everyone,
I am trying to write a stored procedure that should create multiple "virtual tables" from the remote source using statement :
CREATE VIRTUAL TABLE "<schema>"."<table_name>" AT "<remote_source>"."<Database>"."<schema>"."<table>";
But when I try to execute it, it fails with below error :
Error: (dberror) [7]: feature not supported: DDL statements other than CREATE/DROP TABLE is/are not supported in procedure: line 7 col 0 (at pos 135)
Is it documented somewhere, what type of statements are allowed or not in a stored procedure ?
Best Regards,
Vivek Sahu