ChristBoy
asked on
How to change Oracle SP to UDB SP in Visual Age for JAVA?
my original source is used for ORACLE :
sql = " DECLARE";
sql += " CURSOR line is";
sql += " " + SelectStatment + ";";
sql += " lrec line%ROWTYPE;";
sql += " CNT NUMBER(7):=1;";
sql += " BEGIN";
sql += " OPEN line;";
sql += " WHILE CNT <= " + PersonCount + " LOOP";
sql += " FETCH line INTO lrec;";
sql += " EXIT WHEN line%NOTFOUND;";
sql += " " + InsertStatment + ;";
sql += " CNT := CNT + 1;";
sql += " END LOOP;";
sql += " CLOSE line;";
sql += " END; ";
db.executeUpdate(sql);
How can I change this SP to avaliable for UDB?
sql = " DECLARE";
sql += " CURSOR line is";
sql += " " + SelectStatment + ";";
sql += " lrec line%ROWTYPE;";
sql += " CNT NUMBER(7):=1;";
sql += " BEGIN";
sql += " OPEN line;";
sql += " WHILE CNT <= " + PersonCount + " LOOP";
sql += " FETCH line INTO lrec;";
sql += " EXIT WHEN line%NOTFOUND;";
sql += " " + InsertStatment + ;";
sql += " CNT := CNT + 1;";
sql += " END LOOP;";
sql += " CLOSE line;";
sql += " END; ";
db.executeUpdate(sql);
How can I change this SP to avaliable for UDB?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
OK. Thanks. :-)
Jim
Jim
I will leave a recommendation in the Cleanup topic area that this question is:
- points to jim_cakalic@idg
Please leave any comments here within the
next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !
girionis
Cleanup Volunteer