存储过程 编译错误:PLS-00103: Encountered the symbol "TABLE" when expecting one of the following:
来源:互联网 发布:松竹梅清酒 知乎 编辑:程序博客网 时间:2024/05/17 04:45
必须使用动态的语句, DDL 语句,在存储过程中, 需要改为动态语句 :
execute immediate 'sql语句' ;
我的是因为执行了
truncate table t_pvbdp_comprehensiv_statistic换成
execute immediate 'truncate table t_pvbdp_comprehensiv_statistic' ;
就可以了
DDL 语句指 :
DDL create table 创建表 alter table 修改表 drop table 删除表 truncate table 删除表中所有行 create index 创建索引 drop index 删除索引当执行DDL语句时,在每一条语句前后,oracle都将提交当前的事务。如果用户使用insert命令将记录插入到数据库后,执行了一条DDL语句(如create table),此时来自insert命令的数据将被提交到数据库。当DDL语句执行完成时,DDL语句会被自动提交,不能回滚。
0 0
- 存储过程 编译错误:PLS-00103: Encountered the symbol "TABLE" when expecting one of the following:
- PLS-00103: Encountered the symbol "" when expecting one of the following
- PLS-00103:Encountered the symbol "EXIT" when expecting one of the following:.( ,%
- PLS-00103: Encountered the symbol "CREATE"
- PLS-00103: Encountered the symbol "CREATE"
- 存储过程PLS-00103
- Which of the following statements describe the result when standard new CANNOT allocate the requeste
- ocp 047-40 User OE, the owner of the ORDERS table, issues the following command:
- 58.The PART_CODE column in the SPARES table contains the following list of values:
- The given filter instance must implement one or more of the following filter interfaces
- Question 11: Which of the following statements describe the result when standard new cannot allocate the requested storage in C+
- Which of the following expression(s) will NOT cause an error when used to replace the ***** in the C
- manuscript of the fourth generation of great designs the following is a table with the number varie
- 上传苹果应用 At least one of the following architecture(s) must be present: armv6 (-19033)
- this product is covered by one or more of the following
- Git: The following paths are ignored by one of your .gitignore files: xxx.dll
- Encountered "lili" at line 26, column 12. Was expecting one of: <NEWLINE>
- 144.You execute the following command to change the status of the SALES tablespace: SQL> ALTER TABLE
- java中不常见的关键字:strictfp,transient
- 【caffe源码研究】第四章:完整案例源码篇(2) :LeNet初始化训练网络
- Spring boot中使用log4j记录日志
- JS之定义指定时间的Date对象
- continue 和 break
- 存储过程 编译错误:PLS-00103: Encountered the symbol "TABLE" when expecting one of the following:
- url当前目录与根目录
- mysql 拼接字符串已达到预期效果
- QT更改窗口名称
- java.lang.UnsatisfiedLinkErro...nativeLibraryDirectories...couldn't find "libluajava.so"
- [置顶] [总结]FFMPEG视音频编解码零基础学习方法
- 【Http认证】Http的四种认证方式
- 用java实现:判断1-100之间有多少个素数,并输出所有素数
- php几种运行模式