using MSDATASHAPE and Oracle sp/pkg


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: using MSDATASHAPE and Oracle sp/pkg

  1. #1
    Chris Hylton Guest

    using MSDATASHAPE and Oracle sp/pkg


    Anybody actually used this combination and get a SP to work through an ADO
    command object ?

    I'm trying to execute a SP through an ADO connection established using the
    MSDATASHAPE provider.

    I'm not trying to use a SP to return a result set, just execute a basic SP
    that uses IN/OUT parameters...but, want to be able to call it through and
    ADO connection that uses MSDATASHAPE as the base provider with the data provider
    set to MSDAORA.

    I get an error about the format of the statement that ADO is attempting to
    pass through to Oracle...don't remember the exact error. It works fine if
    I just connect using MSDAORA (as you'd expect).

    I'm guessing that you might not be able to do this, but I've yet to find
    any documenation on it either way.

    I could establish two connections...one w/ MSDATASHAPE for my shaped queries...and
    then one w/ MSDAORA to handle procs...but that's two connections to the DB
    and one can't see the changes of the other inside a transaction.

    Chris

  2. #2
    Roy Guest

    Re: using MSDATASHAPE and Oracle sp/pkg

    I might be wrong but I recall reading somewhere that it would only work with MS Access.

    Roy

    "Chris Hylton" <cchylton@hotmail.com> wrote in message news:3d8f3030$1@10.1.10.29...
    >
    > Anybody actually used this combination and get a SP to work through an ADO
    > command object ?
    >
    > I'm trying to execute a SP through an ADO connection established using the
    > MSDATASHAPE provider.
    >
    > I'm not trying to use a SP to return a result set, just execute a basic SP
    > that uses IN/OUT parameters...but, want to be able to call it through and
    > ADO connection that uses MSDATASHAPE as the base provider with the data provider
    > set to MSDAORA.
    >
    > I get an error about the format of the statement that ADO is attempting to
    > pass through to Oracle...don't remember the exact error. It works fine if
    > I just connect using MSDAORA (as you'd expect).
    >
    > I'm guessing that you might not be able to do this, but I've yet to find
    > any documenation on it either way.
    >
    > I could establish two connections...one w/ MSDATASHAPE for my shaped queries...and
    > then one w/ MSDAORA to handle procs...but that's two connections to the DB
    > and one can't see the changes of the other inside a transaction.
    >
    > Chris




  3. #3
    Ken Guest

    Re: using MSDATASHAPE and Oracle sp/pkg


    "Chris Hylton" <cchylton@hotmail.com> wrote:
    >
    >Anybody actually used this combination and get a SP to work through an ADO
    >command object ?
    >
    >I'm trying to execute a SP through an ADO connection established using the
    >MSDATASHAPE provider.
    >
    >I'm not trying to use a SP to return a result set, just execute a basic

    SP
    >that uses IN/OUT parameters...but, want to be able to call it through and
    >ADO connection that uses MSDATASHAPE as the base provider with the data

    provider
    >set to MSDAORA.
    >
    >I get an error about the format of the statement that ADO is attempting

    to
    >pass through to Oracle...don't remember the exact error. It works fine

    if
    >I just connect using MSDAORA (as you'd expect).
    >
    >I'm guessing that you might not be able to do this, but I've yet to find
    >any documenation on it either way.
    >
    >I could establish two connections...one w/ MSDATASHAPE for my shaped queries...and
    >then one w/ MSDAORA to handle procs...but that's two connections to the

    DB
    >and one can't see the changes of the other inside a transaction.
    >
    >Chris


    My team got into this about a year ago - lot of mucking about for awhile
    but we eventually got shapes working with Oracle stored procs. Will see
    what I can find for you when I get into the office tomorrow.


  4. #4
    Chris Hylton Guest

    Re: using MSDATASHAPE and Oracle sp/pkg


    Ken, thanks...that'd be great...but, just to clarify...

    not trying to actually get a shaped recordset back from two SPs...I can do
    that successfully...

    what i'm trying to do is...execute a standard stored proc w/ standard in/out
    (return) parameters...not to create a shaped recordset, but just to do something
    on the server level...BUT...I'd like to be able to send it through the MSDATASHAPE
    data provider w/ MSDAORA set as the data provider...

    that's where i'm bumping up against a wall...the ADO connection established
    with MSDATASHAPE won't execute a proc...unless it's built into the command
    object as a text string w/ the parameters build into the string...which doesn't
    allow me to get at the parameters once the proc has execute...

    Anyway...that's the problem...hopefully it makes sense...maybe you've got
    some stuff working this way...

    Thanks,
    Chris

    "Ken" <Whittingtonken@sympatico.ca> wrote:
    >
    >"Chris Hylton" <cchylton@hotmail.com> wrote:
    >>
    >>Anybody actually used this combination and get a SP to work through an

    ADO
    >>command object ?
    >>
    >>I'm trying to execute a SP through an ADO connection established using

    the
    >>MSDATASHAPE provider.
    >>
    >>I'm not trying to use a SP to return a result set, just execute a basic

    >SP
    >>that uses IN/OUT parameters...but, want to be able to call it through and
    >>ADO connection that uses MSDATASHAPE as the base provider with the data

    >provider
    >>set to MSDAORA.
    >>
    >>I get an error about the format of the statement that ADO is attempting

    >to
    >>pass through to Oracle...don't remember the exact error. It works fine

    >if
    >>I just connect using MSDAORA (as you'd expect).
    >>
    >>I'm guessing that you might not be able to do this, but I've yet to find
    >>any documenation on it either way.
    >>
    >>I could establish two connections...one w/ MSDATASHAPE for my shaped queries...and
    >>then one w/ MSDAORA to handle procs...but that's two connections to the

    >DB
    >>and one can't see the changes of the other inside a transaction.
    >>
    >>Chris

    >
    >My team got into this about a year ago - lot of mucking about for awhile
    > but we eventually got shapes working with Oracle stored procs. Will see
    >what I can find for you when I get into the office tomorrow.
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center