Results 1 to 2 of 2

Thread: Question regarding oracle and vs2005

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    May 2002
    Posts
    1,602

    Question regarding oracle and vs2005

    Im trying to build my typed datasets using the tableadapter wizard in vs2005 I have two problems:

    1)Why cant I select the "stored procedure" choice when I create my select. All I can select is the top choice "sql query"


    2) When Im working in the query analyzer and I want a parameter, Im used to write @Myparam... But that doesnt seem to work, I get an oracle error.

    Please note that im used to sql server, this is my first oracle project in vs2005!!! I have developed SPs in pl/sql for 2 years....


    kind regards
    Henrik

  2. #2
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,425

    Re: Question regarding oracle and vs2005

    I always use the SQL prompt (from SQL*Plus) to perform all SP testing in Oracle. I have a thread in the FAQ's for the database area on how to do that and retun the resultsets back from a cursor.
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1

Posting Permissions

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



Click Here to Expand Forum to Full Width