locked
oraclemembershipprovider error RRS feed

  • Question

  • i am trying to use oraclemembershipprovider for user authentication using oracle express

    my web.config looks like:

    <add name="ConnectionString" connectionString="data source=OraDbXe;user id=hr; password=hr" />
        <add name="EmpConnectionString" connectionString="DATA SOURCE=;PASSWORD=hr;USER ID=HR"
          providerName="Oracle.DataAccess.Client" />
      </connectionStrings>
      <system.web>

       <membership defaultProvider="SomeOracleMembershipProvider " hashAlgorithmType="SHA1" >
        <providers>
         <clear/>
         <add name="SomeOracleMembershipProvider " applicationName="/SomeApp" passwordFormat="Hashed" type="Oracle.Web.Security.OracleMembershipProvider, Oracle.Web, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89B483F429C47342" requiresQuestionAndAnswer="false" requiresUniqueEmail="false" connectionStringName="ConnectionString" />
        </providers>
       </membership>
       <profile enabled="true" defaultProvider="OracleProfileProvider">
        <properties>
         <add name="FullName" type="string"/>
        </properties>
       </profile>
       <roleManager enabled="true" defaultProvider="SomeOracleRoleProvider">
        <providers>
         <clear/>
         <add name="SomeOracleRoleProvider" applicationName="/SomeApp" connectionStringName="ConnectionString" type="Oracle.Web.Security.OracleRoleProvider, Oracle.Web, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89B483F429C47342" />
        </providers>
       </roleManager>

    when i click security tab on Web Site adminstation tool to create user i get error

    There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

    The following message may help in diagnosing the problem: ORA-06550: line 1, column 15: PLS-00201: identifier 'ORA_ASPNET_MEM_GETALLUSERS' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored  i searched oracle forums  but could find solution.
    i do not have any problem connectiong to oracle database or any problem  using sqlmembershipprovider to create database in sql.

    if any one had tried this please help


    .net developer

    • Moved by Lie You Friday, March 9, 2012 7:14 AM Oracle related. (From:.NET Platform Architecture Development Discussions)
    Monday, March 5, 2012 10:44 PM

Answers

All replies