如何将函数的结果存储在ORACLE中 [英] how to store result of a function to vatiable in 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屋！