ad_message_get.sql

来自「Java写的ERP系统」· SQL 代码 · 共 43 行

CREATE OR REPLACE FUNCTION AD_Message_Get
(
	p_Value			IN NVARCHAR2,
	p_AD_Language	IN VARCHAR2 --	DEFAULT 'USAENG'
)
RETURN NVARCHAR2
AS
/*************************************************************************
 * The contents of this file are subject to the Compiere License.  You may
 * obtain a copy of the License at    http://www.compiere.org/license.html 
 * Software is on an  "AS IS" basis,  WITHOUT WARRANTY OF ANY KIND, either 
 * express or implied. See the License for details. Code: Compiere ERP+CPM
 * Copyright (C) 1999-2001 Jorg Janke, ComPiere, Inc. All Rights Reserved.
 *************************************************************************
 * $Id: AD_Message_Get.sql,v 1.6 2002/10/21 04:49:45 jjanke Exp $
 ***
 * Title:	Get Message
 * Description:
 *			TODO: Translation
 ************************************************************************/
	v_RetValue				AD_Message.MsgText%TYPE;
BEGIN
	BEGIN
		SELECT 	MsgText		--	Message
		  INTO	v_RetValue
		FROM	AD_Message
		WHERE	Value = p_Value;
   	/*POSTGRESQL>
		IF (NOT FOUND) THEN
			RETURN <' || p_Value || '>';
	   	END IF;
  	<POSTGRESQL*/
	/*ORACLE>*/
	EXCEPTION
		WHEN OTHERS THEN
			RETURN N'<' || p_Value || N'>';
	/*<ORACLE*/
	END;
	--
	RETURN v_RetValue;
END AD_Message_Get;
/