Dataset to an oracle stored procedure

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Jawahar Rajan
    #1

    Dataset to an oracle stored procedure

    Is it possible for a Dataset that is added to a C# project to be based on a
    stored Procedure?
    Can I use either a OracleClient or Microsoft Oracle Client?

    Any help is appreciated.


    Jawahar


    Tags: None
    • Miha Markic
      #2
      Re: Dataset to an oracle stored procedure

      Yes, it is possible with both.
      There is no design time support for retrieving dataset metadata with MS'
      Oracle provider.
      I don't know about Oracle's one.

      --
      Miha Markic - RightHand .NET consulting & software development
      miha at rthand com
      https://www.rthand.com


      "Jawahar Rajan" <jrajan@nc.rr.c om> wrote in message
      news:3MsRb.1293 7$F86.1422848@t wister.southeas t.rr.com...[color=blue]
      > Is it possible for a Dataset that is added to a C# project to be based on[/color]
      a[color=blue]
      > stored Procedure?
      > Can I use either a OracleClient or Microsoft Oracle Client?
      >
      > Any help is appreciated.
      >
      >
      > Jawahar
      >
      >[/color]


        Comment

        • Nicholas Paldino [.NET/C# MVP]
          #3
          Re: Dataset to an oracle stored procedure

          Miha and Jawahar,

          While there isn't design time support for retrieving the results of a
          stored procedure using the managed provider for oracle, if you have the OLE
          DB provider installed, you can get the results through that in design time
          and get the data set through that.

          Hope this helps.


          --
          - Nicholas Paldino [.NET/C# MVP]
          - mvp@spam.guard. caspershouse.co m

          "Miha Markic" <miha at rthand com> wrote in message
          news:ON5YXFN5DH A.2732@TK2MSFTN GP09.phx.gbl...[color=blue]
          > Yes, it is possible with both.
          > There is no design time support for retrieving dataset metadata with MS'
          > Oracle provider.
          > I don't know about Oracle's one.
          >
          > --
          > Miha Markic - RightHand .NET consulting & software development
          > miha at rthand com
          > www.rthand.com
          >
          > "Jawahar Rajan" <jrajan@nc.rr.c om> wrote in message
          > news:3MsRb.1293 7$F86.1422848@t wister.southeas t.rr.com...[color=green]
          > > Is it possible for a Dataset that is added to a C# project to be based[/color][/color]
          on[color=blue]
          > a[color=green]
          > > stored Procedure?
          > > Can I use either a OracleClient or Microsoft Oracle Client?
          > >
          > > Any help is appreciated.
          > >
          > >
          > > Jawahar
          > >
          > >[/color]
          >
          >[/color]


            Comment

            • Miha Markic
              #4
              Re: Dataset to an oracle stored procedure

              Hi Nicholas,

              Nice trick :)

              --
              Miha Markic - RightHand .NET consulting & software development
              miha at rthand com
              https://www.rthand.com


              "Nicholas Paldino [.NET/C# MVP]" <mvp@spam.guard .caspershouse.c om> wrote in
              message news:%23ZP$FqN5 DHA.1292@TK2MSF TNGP11.phx.gbl. ..[color=blue]
              > Miha and Jawahar,
              >
              > While there isn't design time support for retrieving the results of a
              > stored procedure using the managed provider for oracle, if you have the[/color]
              OLE[color=blue]
              > DB provider installed, you can get the results through that in design time
              > and get the data set through that.[/color]


                Comment

                Previous template Next
                Working...