我需要用Oracle ProC写一个程式,里面必须有个Delete的SQL,但是我的表名字是动态的。
EXEC SQL DELETE FROM :tmpTableName;
不过这样会报错
Syntax error at line 127, column 39, file c:\proc_sqlldr.pc:
Error at line 127, column 39 in file c:\proc_sqlldr.pc
EXEC SQL DELETE FROM :tmpTableName;
......................................1
PCC-S-02201, Encountered the symbol ":" when expecting one of the following: ( an identifier, a quoted string, date, table, count,
extract, interval, multiset, the, time, timestamp, trim, avg,
max, min, sum, stddev, variance,Syntax error at line 0, column 0, file c:\proc_sqlldr.pc:
Error at line 0, column 0 in file c:\proc_sqlldr.pc
PCC-S-02201, Encountered the symbol "<eof>" when expecting one of the following: ; : an identifier, end-exec, random_terminalError at line 0, column 0 in file c:\proc_sqlldr.pc
PCC-F-02102, Fatal error while doing C preprocessing请问各位大大知道要怎么写,才能把表名写成动态的吗?
先谢
EXEC SQL DELETE FROM :tmpTableName;
不过这样会报错
Syntax error at line 127, column 39, file c:\proc_sqlldr.pc:
Error at line 127, column 39 in file c:\proc_sqlldr.pc
EXEC SQL DELETE FROM :tmpTableName;
......................................1
PCC-S-02201, Encountered the symbol ":" when expecting one of the following: ( an identifier, a quoted string, date, table, count,
extract, interval, multiset, the, time, timestamp, trim, avg,
max, min, sum, stddev, variance,Syntax error at line 0, column 0, file c:\proc_sqlldr.pc:
Error at line 0, column 0 in file c:\proc_sqlldr.pc
PCC-S-02201, Encountered the symbol "<eof>" when expecting one of the following: ; : an identifier, end-exec, random_terminalError at line 0, column 0 in file c:\proc_sqlldr.pc
PCC-F-02102, Fatal error while doing C preprocessing请问各位大大知道要怎么写,才能把表名写成动态的吗?
先谢
解决方案 »
- 請教:RHEL5中oracle database 10g express安裝以及怎樣配置
- 关于oracle存储过程中筛选出错的疑问
- 问个ORACLE 删除主键和索引的问题
- Oracl中的使用utl_file来读取txt文件,数据插入数据库
- Oracle高手请进,300分!一个oracle9i回退段的问题.
- sql server的數據想轉到ORACLE去,有沒有什麼好方法啊???急用啊!!!!!
- orcale 8i 中,data的数据类型是什么样子的?在表中,存在data类型数据,无法插入?
- 我oracle进不处,假如要重新安装oracle,原来的数据库数据还在不在?
- 2个数据库整合起来,成为一个大的数据库,有什么方法可以操作?
- 求解释逻辑standby数据库alert日志频繁报ORA-19815而实际操作系统空间没有使用
- 请大家帮忙提供一个算法,用sql可以筛选出手机号码靓号~~~~~
- 求教:用脚本实现plsql developer的export user objects功能
EXEC SQL EXECUTE IMMEDIATE :s;试试这个方法。