IF agent Action

[kumar]

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

[raj73]

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

[kumar]

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

[raj73]

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.