PLS-00103-存储过程中运作alter table
日期：2014-05-16 浏览次数：20477 次
PLS-00103-存储过程中运行alter table
存储过程中运行alter table出现如下错误：
?
?
Compilation errors for PROCEDURE PDS.UNDOMERCHANTACCOUNT
Error: PLS-00103: Encountered the symbol "ALTER" when expecting one of the following:
begin case declare end exception exit for goto if loop mod
null pragma raise return select update while with
<an identifier> <a double-quoted delimited-identifier>
<a bind variable> << close current delete fetch lock insert
open rollback savepoint set sql execute commit forall merge
pipe
Line: 21
Text: alter table TBL_TEST storage(buffer_pool default);
?
Error: PLS-00103: Encountered the symbol "ALTER" when expecting one of the following:
begin case declare end exception exit for goto if loop mod
null pragma raise return select update while with
<an identifier> <a double-quoted delimited-identifier>
<a bind variable> << close current delete fetch lock insert
open rollback savepoint set sql execute commit forall merge
pipe
Line: 21
Text: alter table TBL_TEST storage(buffer_pool default);
?
解决方法：
?
动态SQL:
?
?
execute immediate 'alter table xxx';
?
?
?
?
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
