CREATE OR REPLACE add_s(p_no NUMBER,p_name VARCHAR2,p_cnu NUMBER)
AS
BEGIN
INSERT INTO cla VALUES(p_cnu);
INSERT INTO stu VALUES(p_no,p_name,p_cnu);
COMMIT;
EXCEPTION WHEN OTHERS THEN
dbms_output.put_line('no');
END;
出现选项缺失或无效 为什么呢?
AS
BEGIN
INSERT INTO cla VALUES(p_cnu);
INSERT INTO stu VALUES(p_no,p_name,p_cnu);
COMMIT;
EXCEPTION WHEN OTHERS THEN
dbms_output.put_line('no');
END;
出现选项缺失或无效 为什么呢?
解决方案 »
- 请帮忙看下这段ps sql代码哪里有问题。
- oracle 9i v$sql视图 如何产看sql语句内的参数值?
- 8i的客户端能连10g的服务器吗?
- ORACLE 9I数据库字符集是BIG5,保存简体字出现乱码
- 问一个比较难的sql,大哥大姐帮帮忙阿,急啊,分不够再加
- 急:请问LogMiner 在哪里能下载?在线等!!
- [高手请进]:关于sql的优化机制
- 进SQL*PLUS时,提示错误:ORA-01033: ORACLE initialization or shutdown in progress
- 如何取交集?PL/SQL
- 我想获得oracle中毫秒级的时间单位有什么好办法吗?
- count(*),count(1)和count(主键)的区别
- 求视频教程:PL/SQL系列高级编程及大型B2C商城项目数据库实战
CREATE OR REPLACE add_s(p_no NUMBER,p_name VARCHAR2,p_cnu NUMBER)
AS
BEGIN
INSERT INTO cla(栏位名) VALUES(p_cnu);
INSERT INTO stu(栏位名) VALUES(p_no,p_name,p_cnu);
COMMIT;
EXCEPTION WHEN OTHERS THEN
dbms_output.put_line('no');
END;
加上了 还是这个错误
我建表的过程是这样的 ,你看下
CREATE OR REPLACE PROCEDURE CREATE_S_C AS
SQL_C1 VARCHAR2(1000);
SQL_C2 VARCHAR2(1000);
BEGIN
SQL_C1 := ' CREATE TABLE CLA(cno NUMBER PRIMARY KEY )';
EXECUTE IMMEDIATE 'sql_c1';
COMMIT;
SQL_C2 := ' CREATE TABLE STU(NU NUMBER PRIMARY KEY, NAME VARCHAR2(10),CNO NUMBER REFERENCES CLA(CNO));';
EXECUTE IMMEDIATE 'sql_c2';
COMMIT;
EXCEPTION
WHEN OTHERS THEN
EXECUTE IMMEDIATE 'no';
EXECUTE IMMEDIATE 'sql_c1';
EXECUTE IMMEDIATE 'sql_c2';
END;问题在哪里呢???
你想创建什么?
存储过程?
CREATE OR REPLACE procedure add_s
CREATE OR REPLACE Procedure add_s(p_no NUMBER,p_name VARCHAR2,p_cnu NUMBER)
AS
BEGIN
INSERT INTO cla(cno) VALUES(p_cnu);
INSERT INTO stu(nu,NAME,cno) VALUES(p_no,p_name,p_cnu);
COMMIT;
EXCEPTION WHEN OTHERS THEN
dbms_output.put_line('no');
END;
CREATE OR REPLACE Procedure add_s(p_no NUMBER,p_name VARCHAR2,p_cnu NUMBER)
AS
BEGIN
INSERT INTO cla(cno) VALUES(p_cnu);
INSERT INTO stu(nu,NAME,cno) VALUES(p_no,p_name,p_cnu);
COMMIT;
EXCEPTION WHEN OTHERS THEN
dbms_output.put_line('no');
END;
SQL_C1 VARCHAR2(1000);
SQL_C2 VARCHAR2(1000);
BEGIN
SQL_C1 := ' CREATE TABLE CLA(cno NUMBER PRIMARY KEY )';
EXECUTE IMMEDIATE 'sql_c1';
COMMIT;
SQL_C2 := ' CREATE TABLE STU(NU NUMBER PRIMARY KEY, NAME VARCHAR2(10),CNO NUMBER REFERENCES CLA(CNO));';
EXECUTE IMMEDIATE 'sql_c2';
COMMIT;
EXCEPTION
WHEN OTHERS THEN
EXECUTE IMMEDIATE 'no';
EXECUTE IMMEDIATE 'sql_c1';
EXECUTE IMMEDIATE 'sql_c2';
END;这段代码为什么我执行不通过呢???