SQL Cursor : Database Object That Provisions Access to Records in a Database
0
votes
1answer
30 views
Is the data fetched by an explicit cursor immutable in PL/SQL?
This seems like an obvious question, but Googling has so far failed me...
Say I have a view which delineates updates that I need to apply and, to this end, I have an SP that opens the view as a ...
-2
votes
1answer
27 views
Following procedure generates an error and I cannot find the reason [closed]
create or replace procedure buyunits is
mnav number;
mpno varchar2(100);
mtransactioncharge number;
mservicecharge number;
maccno number;
cursor ecursor is
select accno from sipholder where ...
-2
votes
1answer
71 views
how cursor implementations are different for each cursor type in sql server
In Oracle, there are only 2 types of cursor i.e. Implicit and Explicit cursor. Which is easy to understand. But, in SQL Server there are 4 Cursor AFAIK i.e. Static,Dynamic,Forward Only and Scroll. ...
-1
votes
1answer
107 views
I need help in Nested Cursors in SQL server
I need to use Member table, Member_Account table and Class table to calculate Monthly Fee of any member, i've created a procedure and nested cursors for this purpose, please help if anyone understands ...
0
votes
1answer
55 views
Invalid rowid error
I'm trying to see, how UPDATE Lock helps to minimize error while dml (delete/update) operations.
declare
cursor update_lock is select empno from emp where deptno=&no for update of sal;
num ...
1
vote
1answer
488 views
How to return resultset from MySQL Stored Procedure using prepared statement?
DELIMITER $$
CREATE PROCEDURE List_IL()
BEGIN
DECLARE Project_Number_val VARCHAR( 255 );
DECLARE Temp_List_val VARCHAR(255);
DECLARE Project_List_val VARCHAR(255);
DECLARE FoundCount INT;
...
1
vote
1answer
58 views
Internal architecture of cursors
I know that cursor isn't very good idea, but I have some questions for internal structure of cursor.
First step in cursor is determining result set which cursor iterate over. So, did cursor execute ...
1
vote
0answers
54 views
Map records to a time interval
I have two tables:
SamplesTbl contains samples every 5 seconds of a bike ride
RxTbl contains the prescribed stages and other values of a bike ride
SamplesTbl
SamplesID int
SessionNum int
StageNum ...
5
votes
1answer
327 views
Executing SPs in parallel (maybe with a cursor) [closed]
We have an 3rd party accounting system that runs on SQL Server 2008 R2. To insert invoices into this accounting system, we have to use the API that comes with it (which is just a set of encrypted ...
3
votes
0answers
234 views
SQL Server 2008 R2 clustered index issue
Last week, we came up with a strange issue on Clustered index. We are using SQL Server 2008 R2 in our organization.
A stored procedure is written for our application which contains a cursor in it. ...
0
votes
2answers
197 views
limit and then group by in MySQL
I have a mysql table having following structure :
payment_id(int auto_increment),
emp_id(int),
chargeTime(datetime),
payment(double)
I need to have three latest (with respect to chargeTime) ...
2
votes
2answers
1k views
MySQL: Loop over cursor results ends ahead of schedule
I'm executing a loop that iterates over a cursor's results. The code is inside a trigger function, and the part that matters looks like that:
EDIT: Sorry, stupid mistake. The trigger is executed ...
2
votes
2answers
212 views
Bug in PL/pgSQL function creation
I don't know if this question better suits here or in SO ...
This is a script that I'd like to launch (the code of the function was copied from a question on SO):
\c mydb
create or replace function ...
1
vote
1answer
207 views
This refactoring from cursor on a dblink'ed Oracle table OK?
The data is being compared from the local version of the table to one in the contracts linked server. I'm not certain what the goal of this code is in the first place, but I'm trying to get a handle ...
2
votes
2answers
77 views
Performing a “Spread Negitive” over a dataset
I have a situation where a table that represents outstanding balances and credits are both contained in one table. What I need to do is apply all outstanding credits (preferably in order of oldest ...
3
votes
1answer
139 views
Optimization around static cursor use
I'm currently in-house support for a vendor-supplied application which uses static cursors to crawl through a list of data. I've leaned on the vendor as much as I can to fix their cursor use with no ...
1
vote
3answers
258 views
Find and remove gaps in sequence across two different columns
I've tried to solve this problem using a set-based approach. However, since I need to look at each row I think I must use a cursor; please correct me if I'm wrong.
The table:
Project, item, method, ...
1
vote
2answers
900 views
Why is this MySQL proc using cursors failing to retrieve results?
I am importing data from a third-party vendor. I have already imported their tables into my existing database. Now, I just need to iterate through each of their person records, munge it a little bit, ...
1
vote
1answer
300 views
Cursor doesn't print text when I tell it to
I have used WAITFOR combined with a cursor in the following script:
create table orders(orderId int primary key,productId int,productName varchar(20));
insert into orders values(1,11,'book');
insert ...
2
votes
1answer
2k views
declaring cursor to loop over some values in SQL server 2008 R2
I have some business unit such as India, International, US, UK. I have to:
Create a table variable (virtual in-memory table) with columns that match SPROC SP_Report resultset.
Declare a cursor that ...
1
vote
0answers
558 views
stored procedure returns ERROR 1305 (42000): FUNCTION does not exist
I have a stored procedure and function as below
CREATE PROCEDURE ProcName()
begin
....
DECLARE curs CURSOR FOR select A.PList, B.nid from persons A inner join articles B on
A.aid=B.id;
....
...
1
vote
1answer
392 views
When to open your MySQL cursor
A relatively simple question but from all my research I have been unable to find a decent answer.
Which is technically more correct, open your cursor after your handlers have been defined or before ...
2
votes
1answer
490 views
View SQL 2008 sp_cursorexecute Underlying Query and Execution Plan
I'm performance tuning a Dynamics AX application and see in a SQL trace a long-running, high-I/O query of the form exec sp_cursorexecute 1073742882 ... When I try and run that query in a new SQL ...
7
votes
3answers
235 views
When are procedural queries absolutely necessary?
I know that we tend to avoid cursors and loops within SQL Server at every cost, but what are some of the situations where you absolutely need procedural queries, and set-based queries just will not ...
0
votes
1answer
263 views
Date Format in Sql Server
I am importing data from another sources, which has multiple columns but I am facing problem in date column like I have multiple format in this column like:
dd/mm/yyyy
mm/dd/yyyy
mmm-yyyy
Can you ...
1
vote
1answer
723 views
Inner cursor performance issues
Before I tried to avoid using cursor because of performance issues. But now I have to do some calculations to reach some goals. I have a stored procedure that has a code like this:
DECLARE ...
