Oracle permissions in WCF Lob adapter

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Oracle permissions in WCF Lob adapter

Viewing 1 reply thread
  • Author
    Posts
    • March 11, 2009 at 5:56 AM #21890
      community-content

        Hi, which permissions do I need to generate XSD schemas using WCF Oracle LOB adapter?

        I’m receiving a “ORA 942- table or view does not exist” but when I run a pl/sql script or C# code using same packages everything works fine.

        Any ideas?, thanks in advance.

      • March 13, 2009 at 5:19 AM #21916
        community-content

          I answer myself, problem arises because WCF Lob adapter uses ODP.Net 10g, and we´re trying to connect with a Oracle 8i.

          ODP.Net 10g uses “ALL_PROCEDURES” view to list packages which it doesn’t exist in 8i.

      • Author
        Posts
      Viewing 1 reply thread
      • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.