create table T_AUDIT
(
AUDIT_ID NUMBER not null,
PROC_ID NUMBER not null,
PROC_PROV_GROUP NUMBER,
AUDIT_TYPE CHAR(1) not null,
INPUT_FILE VARCHAR2(128) not null,
INPUT_PATH VARCHAR2(255),
COUNT NUMBER,
FEE NUMBER,
DISCOUNT NUMBER,
TOTAL_TIME NUMBER,
COUNT2 NUMBER,
FEE2 NUMBER
)insert T_AUDIT(aa, bb) values('ccc', 5);
(
AUDIT_ID NUMBER not null,
PROC_ID NUMBER not null,
PROC_PROV_GROUP NUMBER,
AUDIT_TYPE CHAR(1) not null,
INPUT_FILE VARCHAR2(128) not null,
INPUT_PATH VARCHAR2(255),
COUNT NUMBER,
FEE NUMBER,
DISCOUNT NUMBER,
TOTAL_TIME NUMBER,
COUNT2 NUMBER,
FEE2 NUMBER
)insert T_AUDIT(aa, bb) values('ccc', 5);
解决方案 »
- oracle 存储过程 中返回记录集判断有无记录集如何处理
- 求一小VC段程序
- oca,ocp之间的跨度大不大?
- oracle中有没有类似sqlserver2000中columns_updated()的函数
- 我想在每个月初向数据库插入一些记录,可以用触发器吗?如果不能,有什么好的方法吗?
- 我新建的job去哪里了?
- [求救]我要在函数中进行Insert into 操作,并返回一个整数,写好了不知道如何调用?
- 我的机器(带有intel的HT技术的p4 2.6G)上怎么就装不起来oracle的呢?而我的同事的机器(p3的)上就可以呢?
- 眼看到年底了,大家把自己的帖子清理清理。顺便聊聊天。
- 问题:什么是本地管理,,表空间的 local 选项??
- 请教PL/SQL DEV的一个问题
- 为什么我得oracle装不了
CREATE OR REPLACE PACKAGE Ps
AS
PROCEDURE sp_CreateWK_PUSHCNTS;
END Ps;CREATE OR REPLACE PACKAGE Body Ps
AS
PROCEDURE sp_CreateWK_PUSHCNTS;
BEGIN
create table T_AUDIT
(
AUDIT_ID NUMBER not null,
PROC_ID NUMBER not null,
PROC_PROV_GROUP NUMBER,
AUDIT_TYPE CHAR(1) not null,
INPUT_FILE VARCHAR2(128) not null,
INPUT_PATH VARCHAR2(255),
COUNT NUMBER,
FEE NUMBER,
DISCOUNT NUMBER,
TOTAL_TIME NUMBER,
COUNT2 NUMBER,
FEE2 NUMBER
); EXCEPTION
WHEN NO_DATA_FOUND THEN
DBMS_OUTPUT.PUT_LINE('error');
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('error');
END sp_CreateWK_PUSHCNTS;END Ps;_________________________________________________________________________
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00103: Encountered the symbol "CREATE" when expecting one of the following: begin case declare 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
<a single-quoted SQL string> pipe
===========================================
execute immediate 'create table a(a number)';
AS
PROCEDURE sp_CreateWK_PUSHCNTS;
END Ps;
/
CREATE OR REPLACE PACKAGE Body Ps
AS
PROCEDURE sp_CreateWK_PUSHCNTS
as
str varchar2(1000);
BEGIN
str:='create table T_AUDIT(
AUDIT_ID NUMBER not null,
PROC_ID NUMBER not null,
PROC_PROV_GROUP NUMBER,
AUDIT_TYPE CHAR(1) not null,
INPUT_FILE VARCHAR2(128) not null,
INPUT_PATH VARCHAR2(255),
COUNT NUMBER,
FEE NUMBER,
DISCOUNT NUMBER,
TOTAL_TIME NUMBER,
COUNT2 NUMBER,
FEE2 NUMBER
)';
execute immediate str;
EXCEPTION
WHEN NO_DATA_FOUND THEN
DBMS_OUTPUT.PUT_LINE('error');
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('error');
end;
END sp_CreateWK_PUSHCNTS;
/
END Ps;
end;
END sp_CreateWK_PUSHCNTS;
/
END Ps;修改为:
END sp_CreateWK_PUSHCNTS;
END Ps;