oracle 动态DLL 问题--在线等
yqh 2003-08-16 01:41:30 我想在存储过程中建立一个表,在PL/SQL DEVELOPER中执行
DECLARE
cursor_name INTEGER;
rows_processed INTEGER;
sql_string VARCHAR2(4000);
BEGIN
sql_string := 'CREATE TABLE SYS_COMPARISON
(
COMPARISONTYPE VARCHAR2 (10),
COMPARISONCODE VARCHAR2 (10),
COMPARISONNAME VARCHAR2 (50)
)
PARALLEL
';
cursor_name := dbms_sql.open_cursor;
dbms_sql.parse(cursor_name, sql_string, dbms_sql.v7);
rows_processed := dbms_sql.execute(cursor_name);
dbms_sql.close_cursor(cursor_name);
END;
成功了,但是存储过程就出错
PROCEDURE YQH_TEST IS
cursor_name INTEGER;
rows_processed INTEGER;
sql_string VARCHAR2(4000);
BEGIN
sql_string := 'CREATE TABLE SYS_COMPARISON
(
COMPARISONTYPE VARCHAR2 (10),
COMPARISONCODE VARCHAR2 (10),
COMPARISONNAME VARCHAR2 (50)
)
PARALLEL
';
cursor_name := dbms_sql.open_cursor;
dbms_sql.parse(cursor_name, sql_string, dbms_sql.v7);
rows_processed := dbms_sql.execute(cursor_name);
dbms_sql.close_cursor(cursor_name);
END;
错误误号是ORA-01031
这是怎么回事吗?该怎么做?