Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 16, 2006 at 02:25 PM

    Keith,

    Can you give us the Receiver Message that is being sent from XI to your JDBC adapter.

    Also, look into the JDBC adapter and check if there is an issue on that front.

    Regards,

    Bhavesh

    Add comment
    10|10000 characters needed characters exceeded

    • Keith,

      <i>does VARCHAR as supported in XI is type compatible with VARCHAR2(10)</i>

      Just checked,Yes it is compatible.

      Just make the type of type to be STRING and assign the contant VARCHAR to it.

      Regards,

      Bhavesh