存储过程中使用EXECUTE IMMEDIATE提示权限不足，可是单独执行sql没有问题！

2004-12-09 09:22:26 655 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

ad新版本学习笔记（基本包含一套流程）Altium Designer（ad20/ad21/ad22/ad23） ad20-ad23学习笔记，逐渐补全阅读详情

存储过程中使用EXECUTE IMMEDIATE提示权限不足，可是单独执行sql没有问题！

v_sql :=
' create table '
|| i_table
|| ' TABLESPACE '
|| i_table_ts
|| ' PARTITION BY RANGE (REGION_ID) '
|| ' ( '
|| ' PARTITION A VALUES LESS THAN (''B''), '
|| ' PARTITION B VALUES LESS THAN (''C''), '
|| ' PARTITION C VALUES LESS THAN (''D''), '
|| ' PARTITION D VALUES LESS THAN (''E''), '
|| ' PARTITION E VALUES LESS THAN (''F''), '
|| ' PARTITION F VALUES LESS THAN (''G''), '
|| ' PARTITION G VALUES LESS THAN (''H''), '
|| ' PARTITION H VALUES LESS THAN (''I''), '
|| ' PARTITION I VALUES LESS THAN (''J''), '
|| ' PARTITION J VALUES LESS THAN (''K''), '
|| ' PARTITION K VALUES LESS THAN (''L''), '
|| ' PARTITION L VALUES LESS THAN (''M''), '
|| ' PARTITION M VALUES LESS THAN (maxvalue) '
|| ' ) '
|| ' as select * from '
|| i_table_last
|| ' where 1=2 ';

EXECUTE IMMEDIATE v_sql;

请问这是为什么？

...全文