CREATE OR REPLACE PROCEDURE p_DisplayFaction(
v_Faction TFACTION.C_FACTION %TYPE,
v_LEADER TFACTION.LEADER %TYPE,
v_CREATEDATE TFACTION.L_CREATEDATE %TYPE,
v_PERSONS TFACTION.L_PERSONS %TYPE
)AS
BEGIN
SELECT C_FACTION,L_LEADER,L_CREATEDATE,L_PERSONS into v_Faction,v_LEADER,v_CREATEDATE,v_PERSONS FROM TFACTION WHERE C_FACTION=v_Faction;
END p_DisplayFaction;
v_Faction TFACTION.C_FACTION %TYPE,
v_LEADER TFACTION.LEADER %TYPE,
v_CREATEDATE TFACTION.L_CREATEDATE %TYPE,
v_PERSONS TFACTION.L_PERSONS %TYPE
)AS
BEGIN
SELECT C_FACTION,L_LEADER,L_CREATEDATE,L_PERSONS into v_Faction,v_LEADER,v_CREATEDATE,v_PERSONS FROM TFACTION WHERE C_FACTION=v_Faction;
END p_DisplayFaction;
解决方案 »
- ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [keltfill+94]。。。
- ORA-12154: TNS:无法解析指定的连接标志符和ERROR - ORA-12541: TNS:no listener 请问如何解决?
- 一个Sql语句的疑惑,希望得到你们的帮助!
- 提示无效的sql语句, 请问是怎么回事?
- 谁用过9i中的zhs16cgb231280字符集?-大问题
- Oracle导入数据库出错,高手请进!!
- ORACLE的导入、导出问题
- Oralce9i改IP后监听起不来
- 我想从oracle数据表中选择日期在2002-1-1以前的数据,sql语句该怎样写,数据表中的rq字段是日期型的
- oracle在配置Data Guard时,复制数据库时报ORA-12541: TNS: 无监听程序错误,求大神指点迷津
- oracle转sqlserver问题
- 初学作业调度,遇到简单问题,请教!!!
还有在存储过程中 不能用 select * from table_name where ....
必须 a table_name%rowtype;
select * into a from table_name where ....CREATE OR REPLACE PROCEDURE p_DisplayFaction(
v_Faction TFACTION.C_FACTION %TYPE)AS
a TFACTION.C_FACTION%rowtype;
BEGIN
SELECT * into a FROM TFACTION WHERE C_FACTION=v_Faction;
dbms_output.put_line(a.C_FACTION||' '||a,L_LEADER||' '||a.L_CREATEDATE||' '||a.L_PERSONS);
END p_DisplayFaction;