An error occurred while creating a table during the stored procedure, why?

xiaoxiao2021-03-06  73

The stored procedure is as follows:

Create Or Replace Procedure Proc_TMP IS

Dynamic_SQL VARCHAR2 (100);

Begin

Dynamic_sql: = 'CREATE TABLE T_TMP (a varchar2 (24), b varchar2 (24))';

Execute immediate dynamic_sql;

END;

Tip has no permissions, what is the reason?

转载请注明原文地址:https://www.9cbs.com/read-108594.html

New Post(0)