Function

From: <rajeshdhumal_at_gmail.com>
Date: 22 May 2007 05:24:46 -0700
Message-ID: <1179836685.392874.81900@n15g2000prd.googlegroups.com>

i wants to create a function which will return more than one parameter

Example

CREATE OR REPLACE FUNCTION showArticalBrandStyle(ano number,catno number,divno number) RETURN varchar2 IS
artcode varchar2(30);
brand varchar2(10);
tmpVar varchar2(30);
BEGIN

	SELECT artical_code INTO artcode FROM artical WHERE artical_no=ano;
	dbms_output.put_line(substr(artcode,11,3));
	brand:=getbrandname(substr(artcode,11,3),1);
	return(brand);
	SELECT style_name INTO style FROM categorystyle WHERE
	STYLE_NO=SUBSTR(artcode,14,2) and category_no=catno and
	division_no=divno;
	return brand||' '||style;

END; but it is not working Received on Tue May 22 2007 - 07:24:46 CDT