Index: openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-packages-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-packages-create.sql,v
diff -u -N -r1.4 -r1.5
--- openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-packages-create.sql	9 Oct 2001 05:41:20 -0000	1.4
+++ openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-packages-create.sql	31 Jan 2002 03:04:32 -0000	1.5
@@ -14,7 +14,7 @@
 
    function get_name (
        contract_id	in acs_sc_contracts.contract_id%TYPE
-   ) return acs_sc_contracts.contract_id%TYPE;
+   ) return acs_sc_contracts.contract_name%TYPE;
 
    procedure delete (
        contract_name	in acs_sc_contracts.contract_name%TYPE default null,
@@ -165,7 +165,7 @@
 
    function get_name (
        contract_id	in acs_sc_contracts.contract_id%TYPE
-   ) return acs_sc_contracts.contract_id%TYPE
+   ) return acs_sc_contracts.contract_name%TYPE
    is
        v_contract_name	acs_sc_contracts.contract_name%TYPE;
    begin