MQSeries.net :: View topic - Extracting data from multiple tables uisng SP in JDBCAdapter

siva.kasetty · Posted: Tue Apr 08, 2008 5:20 am Post subject:

hi ,
i am trying to Extracting data from multiple tables using an Stored Procedure and creating Business object of the Stored Procedure in JDBC Adapter.

i am created the Stored procedure and also created the Business object using Stored Procedure.
but the connector is not able to pick up the object created.
it is giving error like

[Time: 2007/04/08 08:12:19.047] [System: ConnectorAgent] [SS: JDBCConnector] [Th
read: appPolling (#1246245057)] [Type: Error] [MsgID: 20026] [Mesg: Unsubscribed event from application: Object Name:TEST, Verb: Retrieve.]

for your reference my procedure is:

CREATE OR REPLACE Procedure Test1 (v_empno IN employee.ID%type)
IS
v_ename employee.name%type ;
v_dname dept1.deptname%type ;
CURSOR c1 IS
select e.name, d.deptname from employee e, dept1 d
where e.ID= v_empno and d.deptid = v_dname;
BEGIN
open c1 ;
LOOP
fetch c1 into v_ename, v_dname ;
exit when c1%notfound ;
end loop ;
close c1 ;
end ;

Trigger is:

create or replace trigger keshav
before insert or update on EMPLOYEE
INSERT INTO xworlds_events
VALUES (1797,'JDBCConnector','1797','TEST','Retrieve',1,sysdate,0,'Comments');

Is it possible to pass an aurgument to the store procedure....
if yes how should i pass the value to it when i am creating Business Object of the procedure..........

Please advise