如何将函数的结果存储在ORACLE中 [英] how to store result of a function to vatiable in ORACLE
本文介绍了如何将函数的结果存储在ORACLE中的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我在oracle中有一个返回varchar结果的函数.现在我想将此结果用作参数来调用另一个存储的PROC.我该怎么办... ??
任何帮助表示赞赏.. :)
在此先感谢
i have a function in oracle which returns a varchar result. now i want to use this result as parameter to call another stored PROC. how can i do this....?
any help is appreciated.. :)
thanks in advance
推荐答案
这是我从Oracle数据库中为退还贷款计划名称编写的函数
我认为这可以帮助您解决问题:
It''s my written Function for return loan scheme name from oracle database
i think it''s help you to solve your problem:
CREATE OR REPLACE FUNCTION GETACNAME (Vscheme IN VARCHAR2 , Vacno IN NUMBER)
RETURN VARCHAR2 IS
VAcName VARCHAR2(200);
AcNoType VARCHAR2(2);
BEGIN
SELECT S_ACNOTYPE INTO AcNoType FROM SCHEMAST WHERE S_APPL = Vscheme ;
If AcNoType = 'TD' Or AcNoType = 'SB' Or AcNoType = 'CA' Or AcNoType = 'AG' Or AcNoType = 'GS' Or AcNoType = 'IV' Or AcNoType = 'LK' Then
SELECT AC_NAME Into VAcName FROM DPMaster
WHERE Ac_AcNoType = AcNoType
And AC_TYPE = Vscheme
And AC_NO = Vacno ;
End If;
RETURN VAcName ;
END GETACNAME ;
这篇关于如何将函数的结果存储在ORACLE中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文