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
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;