Hi Sir,

I am writing sqlj program to create cursor for with hold status.

#sql { BEGIN compound atomic static
declare loTest CURSOR WITH HOLD for SELECT NOTES, NOTES1, NOTE2, NOTE3, ID FROM TEST;
open :OUT loTest;
END compound;
};

but when I tried to compile it gives me followinf error. I tried follwoing different type of combination but it gives me same error.

#sql { BEGIN
Open :out loTest CURSOR WITH HOLD for SELECT NOTES, NOTES1, NOTE2, NOTE3, ID FROM TEST;
END;
};

If I dont write out then its compiling properly but at runtime its giving error when it tries to fire executeUpdate on exeuction context.


Compiling ARTest.sqlj
D:
onWebSphereBuildsourcesqljARTest.sqlj:34.12-38.16: Error: Inaccessible Ja
va type for host item loTest (at position #1): iteratorTest.
D:
onWebSphereBuildsourcesqljARTest.sqlj:34.12-38.16: Warning: Unsupported J
ava type for host item loTest (at position #1): iteratorTest.
Total 1 error and 1 warning.

Thanks,
Paresh