Example of using a stored procedure that returns a cursor

Ask a Question related to ASP Database, Design and Development.

  1. #1

    Default Example of using a stored procedure that returns a cursor

    I am using ASP.Net with stored procedures to access an Oracle database.
    I am looking for an example of one that returns a cursor. I would like
    the cursor to be returned from a function.



    *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    Don't just participate in USENET...get rewarded for it!
    George Viveiros Guest

  2. Similar Questions and Discussions

    1. MS SQL stored procedure
      I am new to MS SQL server and stored procedures. I currently have a query that looks like: select from table where fieldname IN...
    2. Using a stored procedure
      I am trying to pass a ProdID to a stored procedure, but I get an error: Error Executing Database Query. Procedure 'PriceBreak' expects...
    3. Stored procedure?
      Stored procedure ?? -- Message posted via http://www.dotnetmonster.com
    4. re-declare (re-use) a cursor in a stored procedure
      >> I am looping through cursors in a sproc ... << Why? This means you are using SQL as if it were a 1950's Cobol program. Since you did not post...
    5. need help on a stored procedure
      I have 2 tables. table1 and table2 I do a select on table1 and join table 2 on id. I want to check newprice in table1. if it is null, I want to...
  3. #2

    Default Re: Example of using a stored procedure that returns a cursor

    George Viveiros wrote:
    > I am using ASP.Net with stored procedures to access an Oracle
    > database. I am looking for an example of one that returns a cursor. I
    > would like the cursor to be returned from a function.
    This is a classic asp newsgroup. While you may be lucky enough to find a
    dotnet-savvy person here who can answer your question, you can eliminate the
    luck factor by posting your question to an appropriate group. I suggest

    microsoft.public.dotnet.framework.aspnet
    or
    microsoft.public.dotnet.framework.adonet

    HTH,
    Bob Barrows
    --
    Microsoft MVP -- ASP/ASP.NET
    Please reply to the newsgroup. The email account listed in my From
    header is my spam trap, so I don't check it very often. You will get a
    quicker response by posting to the newsgroup.


    Bob Barrows Guest

  4. #3

    Default Re: Example of using a stored procedure that returns a cursor


    Thanks

    I forgot to look where I was.
    George


    *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    Don't just participate in USENET...get rewarded for it!
    George Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139