CREATE OR REPLACE PACKAGE pkg_test
AS
TYPE myrctype IS REF CURSOR; PROCEDURE get (p_id NUMBER, p_rc OUT myrctype);
END pkg_test;
/CREATE OR REPLACE PACKAGE BODY pkg_test
AS
PROCEDURE get (p_id NUMBER, p_rc OUT myrctype)
IS
sqlstr VARCHAR2 (500);
BEGIN
IF p_id = 0 THEN
OPEN p_rc FOR
SELECT ID, NAME, sex, address, postcode, birthday
FROM student;
ELSE
sqlstr :=
'select id,name,sex,address,postcode,birthday
from student where id=:w_id';
OPEN p_rc FOR sqlstr USING p_id;
END IF;
END get;
END pkg_test;
/
AS
TYPE myrctype IS REF CURSOR; PROCEDURE get (p_id NUMBER, p_rc OUT myrctype);
END pkg_test;
/CREATE OR REPLACE PACKAGE BODY pkg_test
AS
PROCEDURE get (p_id NUMBER, p_rc OUT myrctype)
IS
sqlstr VARCHAR2 (500);
BEGIN
IF p_id = 0 THEN
OPEN p_rc FOR
SELECT ID, NAME, sex, address, postcode, birthday
FROM student;
ELSE
sqlstr :=
'select id,name,sex,address,postcode,birthday
from student where id=:w_id';
OPEN p_rc FOR sqlstr USING p_id;
END IF;
END get;
END pkg_test;
/
解决方案 »
- 求助,sqlldr能同时运行多个吗?
- 求个简单的JOB问题 急在线等··
- Oracle 9i和sql的区别
- 50分求sql高手写一条复杂的sql语句,会sql的都请进
- 简单问题:PL/SQL 存储过程中,SQL语句太长了,看不见怎么办?
- 【求助】请教下,什么是RAC节点?
- select 帐户问题
- 新建的表怎么用表数据编辑器不能插入数据?
- 请高手帮我找找原因。
- The SourceSet 'instrumentTest' is not recognized by the Android Gradle Plugin. P
- 请问高人,如何将Access数据库导入 Oracle中?
- 谁能解决这个两个问题 高分相送
最后加上一个“/”
如下:
SQL> CREATE OR REPLACE PACKAGE lix AS
2 begin
3 select * from temp;
4 end;
5 /警告: 创建的包带有编译错误。
2 begin
3 select * from LX;
4 end;
5 /
抱歉我还是不明白!
能告诉我个正确的例子吗?
若楼主只想建立一个存储过程,可按如下:
CREATE OR REPLACE PROCEDURE lix as
v number ;
begin
select count(*) into v from lx;
end;