Skip to Main Content
Forums

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Variables in CQL Statements

calvinIsMeNov 23 2012 — edited Nov 27 2012
Hi

Is there any way we can use a variable in any CQL ?
Whenever we build a pattern, sometimes though the pattern remains same over a period of time but the threshold value ( constant ) may change or vary from business of business. If we could have something like a PreparedStatements. Then we may externally change this value without touching the main Query.

I have tried to draft an example below.

Total amount of transaction in a day must not exceed 10,000 USD. Now this 10,000 will be a variable as this value might change from bank to bank or may be trader to trader etc and may be replaced in the CQL by a variable


Regards

Edited by: calvinIsMe on Nov 24, 2012 12:16 AM
This post has been answered by 877753 on Nov 27 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 25 2012
Added on Nov 23 2012
#complex-event-processing, #soa-process-management
5 comments
2,711 views