If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Stored Procedure in Framework Manager

Started by VijethaBadugu, 05 Apr 2010 04:13:49 AM

Previous topic - Next topic

VijethaBadugu

Hi,
I have a stored procedure(SP). I am using this to insert records to a table 'pay info' based on the parameter(month) user selects.
For ex: if i give parameter=4(April month). The stored procedure has to get executed and it has to insert records into a table 'pay info' for the month of April.
When i create SPQS in FM and when i test the QS it is executing successfully but not inserting recors to the table. Same SD works fine in the back end and inserting records to the table
Pls tell me if something wrong in my SD? my SD does not have any output parameters

VijethaBadugu

For a SD input and output parameters are required???
my SD format is
---------------------------------------
create or replace procedure SP_name
begin...
.....
insert into table X
commit;
return(Success or Failure)
end SP_name;