How to call Teradata stored procedure in COgnos 10.1.1

[itgowrishankar]

Hi All,

I am trying to use Store Procedure with Insert, Update and Delete statements. I am able to create Stored procedure Query subject successfully. This new query subject not showing any query items, even having 14 parameters.

My question is, How can we use 'Teradata' based stored procedure in Cognos.  Any steps to follow.

Please provide your valuable inputs, which will help me in achieving this technique

[rajasekharbathala]

Hi,

use cursor as out parameter in SP.

Regards
Bhaskar.

[itgowrishankar]

Hi Bhaskar,

Could you please give an example on cursor with SP..?

I am very new to SP and cursor concept..


Thanks & Regards
Shankar

[rajasekharbathala]

please check this link
http://stackoverflow.com/questions/12321918/calling-an-oracle-stored-procedure-form-cognos

Regards
Bhaskar

[itgowrishankar]

Hi Bhaskar,

The samethis is happening, after implementing the 'cursor' with SP.

REPLACE PROCEDURE Procudure1  (OUT USR_ID CHAR(10))

BEGIN
DECLARE c CURSOR FOR

        SELECT USR_ID FROM Employee;

OPEN c;
END;




Looks, something else has to modify.  Will it help in converting SP to FM 'Function' ?


Thanks and Regards,
Shankar