Hi everyone,
I created stored proc, on my oracle and define it on framework manager,
I use sys_refcurson as an output parameter to get responce database like this example : https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014689693 (https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014689693)
Everything is fine , but I dont know why sometimes, it is broken. It says it doesnot match the output with db on report. I do not know why it is . The screenshot is attached the question.
When I drop stored proc on framework and re create it the issue is fixed , but what is the real solution?
thanks,
Any idea?
Really difficult to tell, but it looks like it's trying to write a record to the database, but the output possibly doesn't match the table that it's writing to. Is the field that it's writing to (assuming that it's doing that) a text field that can take 2 characters for example? Not much help I know...
the procedure is writing and updating the table, table's all columns are varchar2. And I turned back a text like 'successfully inserted' or
'successfully updated' , and the procedure returns as out parameter sys_refcursor. What is the problem I did not understand?
in the attached file , I select data query , I do not select data modifier , because when I select it there is not out value to see what return from the db