utility_test.sql

Java写的ERP系统

CREATE OR REPLACE PROCEDURE Test_Utility
AS
		No			NUMBER;
		keyA		Key_Array;
		valueA		Value_Array;
		nameA		Name_Array;
BEGIN
	No := Utility.GetLookup('354', keyA, valueA, nameA);
	DBMS_OUTPUT.PUT_LINE('No=' || No);
END Test_Utility;