I have created a Java stored procedure that executes a select and update
statement in the procedure owner schema. It works all fine when client
program connects as owner schema to execute the procedure, but it fails in
select statement when I try it connecting using a different schema. The
procedure begins execution but ceases at select. Documentation says Grant
has no effect in such procedures, what can I do?
My environment is DB2 6.1 for AIX.
Than you so much.
Here are the CREATE PROCEDURE statement and Java stored procedure code (it
works when Java client connects using SCHEMA1, but not using SCHEMA2):
CREATE PROCEDURE SCHEMA1.testProc (IN column char(2),OUT result
varchar(1000)) LANGUAGE JAVA MODIFIES SQL DATA PARAMETER STYLE JAVA NOT
FENCED EXTERNAL NAME 'TestProc.testGrant'
public static void testGrant(String column, String result) throws