Please use the Apache issue tracking system for new NetBeans issues (https://issues.apache.org/jira/projects/NETBEANS0/issues) !!
Bug 154747 - Add ability to save results as SQL cursor
Add ability to save results as SQL cursor
Status: NEW
Product: db
Classification: Unclassified
Component: Show Data
6.x
All All
: P4 (vote)
: TBD
Assigned To: Libor Fischmeistr
issues@db
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2008-12-05 14:07 UTC by Roman Mostyka
Modified: 2013-08-01 12:51 UTC (History)
0 users

See Also:
Issue Type: ENHANCEMENT
:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Mostyka 2008-12-05 14:07:16 UTC
Add ability to save results as SQL cursor. In this case IDE automatically generates cursor variables and cursor body.
Not so important and therefore I set priority to P4, but probably, if we have time in the future, it will be nice
feature to have.
Example of generated SQL cursor for PERSON table from "travel" Java DB:

begin
    DECLARE @personid INTEGER;
    DECLARE @name VARCHAR(50);
    DECLARE @jobtitle VARCHAR(50);
    DECLARE @frequentflyer SMALLINT;
    DECLARE @lastupdated TIMESTAMP;
    DECLARE @qry long varchar;

    set @qry = 'select personid, name, jobtitle, frequentflyer, lastupdated from person';
    begin
        declare cur_query cursor using @qry;

        open cur_query;
        lp: LOOP
            FETCH NEXT cur_query INTO ;
            IF SQLCODE <> 0 THEN LEAVE lp END IF;
        END LOOP;
        close cur_query;
    end
end
Comment 1 Jiri Rechtacek 2009-10-16 14:14:49 UTC
Reassigned to new owner.


By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2014, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo