Skip to Content
0
Jun 18, 2020 at 06:41 AM

DDL statements other than CREATE/DROP TABLE is/are not supported in procedure

1894 Views

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