Parameterized SQL with the OleDb Provider to Oracle

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Tom

    #1

    Parameterized SQL with the OleDb Provider to Oracle

    Short and to the point....

    Can a C# application make a parameterized SQL call to a stored procedure,
    where that stored proc receives an Oracle user-defined data type????

    Conceptually, I need to pass a "data structure" to the procedure.

    Passing XML is not an option 'cuz our Oracle environment does not have the
    Oracle XDK installed (don't ask!).

    I am trying to avoid sending N number of distinct args inthe call, since you
    do not know if N is on the order of 10, or 1000.

    Any help is appreciated...t hanks in advance.

    Tom


Working...