CREATE OR REPLACE PROCEDURE spSelPreSettleDate
(
v_TradeDate NUMBER,
v_SettleDay OUT NUMBER
)
AS
BEGIN
IF v_TradeDate IS NULL THEN
v_TradeDate:=HYHQ.BJT2UTC(SYSDATE);
SELECT NVL(SettleDay,0)
INTO
v_SettleDay
FROM SettleStatus a
WHERE a.SettleDay <v_TradeDate
AND a.Flag=0
AND ROWNUM=1
ORDER BY SettleDay DESC;
END IF;
END;BJT2UTC 外部函数
报错
9/1 PLS-00363: expression 'V_TRADEDATE' cannot be used as an assignment target
9/1 PL/SQL: Statement ignored
指导下
(
v_TradeDate NUMBER,
v_SettleDay OUT NUMBER
)
AS
BEGIN
IF v_TradeDate IS NULL THEN
v_TradeDate:=HYHQ.BJT2UTC(SYSDATE);
SELECT NVL(SettleDay,0)
INTO
v_SettleDay
FROM SettleStatus a
WHERE a.SettleDay <v_TradeDate
AND a.Flag=0
AND ROWNUM=1
ORDER BY SettleDay DESC;
END IF;
END;BJT2UTC 外部函数
报错
9/1 PLS-00363: expression 'V_TRADEDATE' cannot be used as an assignment target
9/1 PL/SQL: Statement ignored
指导下
解决方案 »
- oracle中关联字典表查询
- 有关pl/sql的一些问题
- 大家来帮我分析一下这个statspack报告
- modify number to varchar2报错!
- 数据库查询!!在线急等答案啊
- 创建的函数带有编译错误。问题!
- java_pool_size和shared_pool_size问题,急!!在线等!!!谢谢~
- 请各位大哥帮小妹个忙,先谢过了!
- SQLdeveloper连接数据库时出现错误
- 如何编写日期条件是<=的一段时间的数据的SQL
- update嵌套两个select
- linux64位 下 Oracle C++开发 编译出现 /usr/bin/ld: warning: libstdc++.so.5,
v_SettleDay OUT NUMBER) AS
BEGIN
IF v_TradeDate IS NULL THEN
v_TradeDate := HYHQ.BJT2UTC(SYSDATE);
SELECT NVL(SettleDay, 0)
INTO v_SettleDay
FROM SettleStatus a
WHERE a.SettleDay < v_TradeDate
AND a.Flag = 0
AND ROWNUM = 1
ORDER BY SettleDay DESC;
END IF;
END;