Good day all. Help me please. I need insert any notes to KNTA_NOTES. I have an table component in request. in this table comp allow any task+notes. User can change notes and click button ob WF step. After this notes for any chaget tasks can be apdatind. My samle SQL in attach. This working only if changing 1 task. Thanks in advice!!!
Hi all. I change my query ( INSERT INTO ITG_NOTES (NOTE_ID,VERSION,NOTE_TYPE,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,NOTE_TEXT,OWNER_ID) select itguser.ITG_NOTES_S.NEXTVAL ......
) and all working fine. We try kRunCacheManager.sh but it not help us.
We find any problem again.
We update table from user who have rights for update DB (ITGUSER).If i chech my insert with help another query then all fine but if i chech my insert from another user who have't rights for update DB query not show inserting result. I think this mean that we can se change from interface and from my reports and portlets. Why? How i can solve this? Thanks in advice!!!!!
Probably the most common would be to create a short PL/SQL function and run the function from the execution step with proper values provied in the form of TOKENs. I have also seen people run scripts from execution steps directly utilizing WF Step Commands to create, run and delete scripts after execution. Thanks. -Raj