Ask a Question related to ASP Database, Design and Development.
-
George Viveiros #1
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
-
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... -
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... -
Stored procedure?
Stored procedure ?? -- Message posted via http://www.dotnetmonster.com -
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... -
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... -
Bob Barrows #2
Re: Example of using a stored procedure that returns a cursor
George Viveiros wrote:
This is a classic asp newsgroup. While you may be lucky enough to find a> 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.
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
-
George #3
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



Reply With Quote

