Hi ,
I am new on Java Stored Procedure. Our application is a java based application connecting to progress DB.
Below is a sample of stored procedure we write. I want to set isolation level to Read Uncommitted. With out that, its creating share locks. Can any one tell me how to set isolation level in this procedure.
When i give the following, its shows syntax error.Please help..
CREATE PROCEDURE TestLock9
()
BEGIN
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; -- Error throwing here.
SQLCursor sqlOffDef=null;
select * from offlag;
sqlOffDef= new SQLCursor("select * from offflag ");
sqlOffDef.open();
sqlOffDef.fetch();
while(sqlOffDef.found())
{
sqlCruDef.fetch();
}
END
I am new on Java Stored Procedure. Our application is a java based application connecting to progress DB.
Below is a sample of stored procedure we write. I want to set isolation level to Read Uncommitted. With out that, its creating share locks. Can any one tell me how to set isolation level in this procedure.
When i give the following, its shows syntax error.Please help..
CREATE PROCEDURE TestLock9
()
BEGIN
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; -- Error throwing here.
SQLCursor sqlOffDef=null;
select * from offlag;
sqlOffDef= new SQLCursor("select * from offflag ");
sqlOffDef.open();
sqlOffDef.fetch();
while(sqlOffDef.found())
{
sqlCruDef.fetch();
}
END
