XQE-DAT-0001 Data source adapter error: java.sql.SQLException: Invalid column in

[s.aravindkumar]

 Hi all,

please help me on the below issue

I have imported a procedure from oracle database successfully in framework manager when i am trying to validate i am getting below error.


"XQE-DAT-0001 Data source adapter error: java.sql.SQLException: Invalid column index - when processing query :call ORACLE1.test1(50)".



The procedure which i am trying to validate is

create or replace procedure ORACLE1.test1(ID1 NUMBER) as
begin
INSERT INTO ORACLE1.EMPLOYEES(ID) VALUES (ID1);
COMMIT;
end;



Thanks in Advance,

Aravind Kumar Sekarr

[MFGF]

Hi all,

please help me on the below issue

I have imported a procedure from oracle database successfully in framework manager when i am trying to validate i am getting below error.


"XQE-DAT-0001 Data source adapter error: java.sql.SQLException: Invalid column index - when processing query :call ORACLE1.test1(50)".



The procedure which i am trying to validate is

create or replace procedure ORACLE1.test1(ID1 NUMBER) as
begin
INSERT INTO ORACLE1.EMPLOYEES(ID) VALUES (ID1);
COMMIT;
end;



Thanks in Advance,

Aravind Kumar Sekarr

Hi,

If you open the stored procedure query subject in FM and look at the "Type" option, what is it set to? Data Query or Data Modification? If the former, FM is expecting it to return a result set with a defined projection list (ie a known set of return values to be displayed), and your procedure doesn't return a set of items...

MF.

[s.aravindkumar]

Hi MFGF,

Thanks for the response.

Actually I am New to Cognos. The Type I kept as 'Data query'.
In my prodcedure I am not returing any values just trying to insert data into table in Oracle database.

Thanks in Advance,

Aravind Kumar Sekar

[MFGF]

Hi MFGF,

Thanks for the response.

Actually I am New to Cognos. The Type I kept as 'Data query'.
In my prodcedure I am not returing any values just trying to insert data into table in Oracle database.

Thanks in Advance,

Aravind Kumar Sekar

Hi,

As above, if your SP is set to be 'Data Query', Cognos is expecting it to query the database and return a result set it can parse. You're seeing the error because your SP doesn't do this and Cognos needs it to. If you set it to be 'Data Modification', it doesn't need to return a result set, but then you can only call it from an Event Studio agent, not as an object you can report from in a report...

Cheers!

MF.