In this blog post, let’s learn about the error message “337 Cannot create view on temporary table table-name.” in Hydra and the description of the error.
Error Message
337 Cannot create view on temporary table table-name.
Error Details
Views can be created only on permanent tables. The SELECT statement that defines the view in this latest statement contains the name of the temporary table, table-name. If you did not intend to name a temporary table, check the spelling of table-name. See the discussion of error -313 for a way to display the names of all permanent tables in the database.