Announcement

Collapse
No announcement yet.

IF agent Action

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • IF agent Action

    Hi All,

    I am writing agent with IF agent action. where i need to compare two values.

    IF agent action is working fine only when expression has "=" when i use the "<" or ">" it says "INVALID EXPRESSION".

    when i try to compare two values using saved condition (By using ">" or "<" in the where clause), below error occures
    "Number of place holders not equal to number of pk arguments"

    Kindly suggest me how to use the "<" or">" in the IF agent Action.

    Regards,
    Kumar

  • #2
    Re: IF agent Action

    Hi Kumar,

    I believe you cannot use < or > in expressions.Please try if you workaround with <>. Otherwise, you will need to use saved condition/query to enforce < or > comparison. You could define the saved condition as 'A_GT_B' and use a query like "Select 'Y' From Dual where A > B" (A & B could be columns from the table or variables defined in your agent). If the saved query is defined properly you should not receive errors like above. Hope this helps.

    BR,
    Raj

    Comment


    • #3
      Re: IF agent Action

      Thanks Raj for your reply,

      Agent Saved Query is not supporting < or > comparison, The Query which has the < or > comparision is working fine in TOAD but same is not working in Agent Saved Query and same error occured
      Error : "Number of place holders not equal to number of pk arguments"

      Kindly suggest me how to use the "<" or">" in the IF agent Action.

      Regards,
      Kumar

      Comment


      • #4
        Re: IF agent Action

        Kumar- Agents usually support the usage of saved queries with < or >. Probably, I can be of some help further if you can share the query.

        Comment

        Working...
        X
        😀
        🥰
        🤢
        😎
        😡
        👍
        👎