在pl/sql中的同一过程中创建表并进行插入 [英] Creation of table and insertion within the same procedure in pl/sql
本文介绍了在pl/sql中的同一过程中创建表并进行插入的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我试图创建一个表,然后在pl/sql中的同一过程中向其中插入一些值.我尝试运行以下查询未成功:
I'm trying to create a table and then insert some values in it within the same procedure in pl/sql. I tried to run the following query without success:
create or replace Procedure insertval8(id_no in number,e_name in char)
is
begin
execute immediate 'create table edu2(id number(20), name char(12))';
insert into edu2 values(&id_no,&e_name);
end;
显示
LINE/COL ERROR
-------- -----------------------------------------------------------------
5/1 PL/SQL: SQL Statement ignored
5/13 PL/SQL: ORA-00942: table or view does not exists
在我删除插入代码之前,错误仍然存在.
The error persists until I remove the insert code.
推荐答案
无法编译该过程,因为该表在编译时不存在.
The procedure cannot be compiled because the table is not present at compile time.
还可以在立即执行中包装插入内容,或使用全局临时表(通常是临时数据的首选解决方案).
Wrap the insert in execute immediate also, or use a global temporary table (generaly the preferred solution for temporary data).
create or replace procedure insertval8 (id in number,
name in char )
is
begin
execute immediate 'create table edu2(id number(20), name char(12))';
execute immediate 'insert into edu2(id, name) values (:1, :2)'
using id, name;
end;
这篇关于在pl/sql中的同一过程中创建表并进行插入的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文