oracle存储过程1
CREATE OR REPLACE FUNCTION F_OBTAIN_FTP_ATTRVALUE (apsi_record_id IN VARCHAR2) RETURN VARCHAR2IS attributevalue VARCHAR2 (4000); CURSOR cur IS SELECT attribute_value FROM t_apsi_prod_attr_record WHERE apsi_prod_record_id = apsi_record_id AND attribute_value IS NOT NULL;BEGIN attributevalue := ' '; FOR c IN cur LOOP --if(attributevalue='') then -- dbms_output.put_line('none^^'); -- end if; --dbms_output.put_line('begin^^'||attributevalue); -- dbms_output.put_line('c.ATTRIBUTE_VALUE'||c.ATTRIBUTE_VALUE); IF (attributevalue = ' ') THEN attributevalue := c.attribute_value; DBMS_OUTPUT.put_line ('begin attributevalue^^' || attributevalue); ELSE attributevalue := attributevalue || '|' || c.attribute_value; DBMS_OUTPUT.put_line ('end attributevalue^^' || attributevalue); END IF; END LOOP; RETURN attributevalue;END;