Devart Forums

Code: Select all

       ''' 
        ''' There are no comments for Get_App_Role_List in the schema.
        ''' 
         _
        Public Function Get_App_Role_List( Sappname As String) As System.Int32
            Dim res As IExecuteResult = Me.ExecuteMethodCall(Me, CType(MethodInfo.GetCurrentMethod(), MethodInfo), Sappname)
            Return CType(res.ReturnValue, System.Int32)
        End Function


 PROCEDURE Get_App_Role_List(sAppName IN VARCHAR2, cData OUT cOutput) IS 
   /* --------------------------------------------------------------------------- 
          Procedure:    Get_App_Role_List 
          Developer:      Ed Staffin 
          Date:           12/5/8
          Description:  GET  list of roles
       --------------------------------------------------------------------------- */ 
  
      BEGIN 
          sProcName := 'Get_App_Role_List'; 
          OPEN cData FOR 
          SELECT ROLE_CODE, ROLE_DESC
          FROM APP_ROLE
        WHERE APP_NAME = sAppName; 
                                                          
      EXCEPTION 
      WHEN OTHERS THEN 
          BEGIN 
            COMMON.COMMON_PKG.Log_Error(APPNAME, USER, SQLERRM, sProcName); 
            RAISE_APPLICATION_ERROR(ORAERROR, 'An error has occurred.  Please contact system support for resolution'); 
          END; 
  END Get_App_Role_List;           

Code: Select all

Code: Select all

DataContext.Designer.cs

/// 
        /// There are no comments for Getfornecedores in the schema.
        /// 
        [Function(Name=@"TEST.PK_TEST.GETFORNECEDORES")]
        public System.Int32 Getfornecedores([Parameter(Name="ID_TIPO", DbType="VARCHAR2")] string IdTipo, [Parameter(Name="PAIS", DbType="VARCHAR2")] string Pais, [Parameter(Name="LOCALIDADE", DbType="NUMBER")] System.Nullable Localidade)
        {
            IExecuteResult _GetfornecedoresResult = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), IdTipo, Pais, Localidade);
            return ((System.Int32)(_GetfornecedoresResult.ReturnValue));
        }

Code: Select all

(here is a part of the package)
...
TYPE csGetResultSet is REF CURSOR;
...
PROCEDURE GetFornecedores( id_tipo VARCHAR2, pais VARCHAR2, localidade NUMBER, resultado OUT csGetResultSet)