Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, UK, Berkshire, England
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Oracle stored procedures (VB.NET)

    Is there anyway to edit Oracle stored procedures?
    - I was wondering if the new Oracle .NET data provider would provide this functionality

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, UK, Berkshire, England
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Oracle stored procedures (VB.NET)

    I think I've found out what my problem was, I'd created the connection in the VS.NET Server Explorer using the Oracle Provider for OLE DB. When I changed to the Microsoft OLE DB for Oracle, I can edit procedures, etc.
    Other things changed as well, with the Microsoft driver, additional options appeared, so Database Diagrams, Synonyms, Functions, Package Specifications and Package Bodies are there. WIth the Oracle driver, things like ALL_ALL_TABLES appears in Tables, whereas the Microsoft driver has that under Synonyms

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •