Here I got a scenario: When I press a button in client application (developed in Delphi) a stored procedure is activated. The stored procedure first declares a cursor for a select statement which retu
Closed. This question is opinion-based. It is not currently accepting answers. 开发者_StackOverflow社区
SQL Server 2005 I have a table containing the following: - [order_id][index_1] 6000200010 6000200020 6000200020
I apologize if I am missing something really obvious. I\'m making successive calls to app engine using cursors.How do I tell if the I\'m on the last cursor?The current way I\'m doing it now is to sav
I am trying to call a stored procedure between python and an o开发者_运维知识库racle db. The problem I am having is passing a cursor out-parameter.
This code works fine in SQL 2005 but appears to miss a random number of records from the end of the select in SQL 2008 or SQL 2008R2.I use this code to backup databases on my production servers.The 20
In the below oracle sql package body, I receive a \"SQL Statement ignored\" error and cannot determine the cause. Please see the SELECT statement of the dborLoans_cursor in the PROCEDUREupdateLoansInL
I have a parent-child relationship in the database. What I need to do is loop through the parent\'s query, and using the parent\'s primary key, got get its children. The issue I am having is that I ne
Imagine I have a mysql cursor 开发者_运维问答and data read. The amount of data might be very big that I want to deal with one line each time.
I\'ve had some bad experiences with cursors causing deadlocks.I have been trying to eliminate cursors wherever possible.When they are unavoidable, I try minimize the amount of work done while the curs
加载中,请稍侯......