Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

STORED PROCEDURE

Hi guys,

I am calling ORACLE stored procedure as :

UPDATE transactions t

SET t.flag = 'FALSE'

WHERE exists

(SELECT e.empcode

FROM empmaster e

WHERE e.comid= comid_in AND

e.locid = locid_in AND

e.empcode = t.empcode)

where comid_in , locid_in are input to stored procedures , but in this case no update operation is done.

If i hardcore the values then procedure is executed correctly , I am wondering why this is happening . Here comid_in and locid_in are of type varchar2(10)

Please help me out.

Regards,

Keith.

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question