- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi Nith,
Sorry for the delayed response.
Thanks a lot for helping me on this. Earlier, I directly referred the process variables in the query which I didnt realize that cause my problem.
For anyone's reference,
Bad practice:
INSERT INTO CREW_FEEDBACK_SENT
(JOB_SEGMENT,
JOB_COUNTRY )
VALUES
(GSI_GENERAL_S.NEXTVAL,
{$ /process_data/crew_feedback_input_form/object/data/xdp/datasets/data/form1/Details/jobsegment $},
{$ /process_data/crew_feedback_input_form/object/data/xdp/datasets/data/form1/Details/jobregion $})
Good practice:
INSERT INTO CREW_FEEDBACK_SENT
(JOB_SEGMENT,
JOB_COUNTRY )
VALUES
(GSI_GENERAL_S.NEXTVAL,
?,?)
use them in Parametrized query & that helps.
Regards,
Krishna
Views
Replies
Total Likes