Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
wrong number or types of arguments in call to gt

<Dec 1, 2014 12:17:54 PM CST> <Emergency> <CQLServer> <BEA-000000> <CREATE QUERY GetHighVolume AS
select
trade.symbol, trade.volume from AdapterOutputChannel [now] as trade
where (trade.volume IS NOT NULL)
and (trade.symbol like 'IBM')
and (trade.symbol = 'IBM')
and (trade.volume > 10)
>
<Dec 1, 2014 12:17:54 PM CST> <Emergency> <CQLServer> <BEA-000000> <CREATE QUERY GetHighVolume AS
select
trade.symbol, trade.volume from AdapterOutputChannel [now] as trade
where (trade.volume IS NOT NULL)
and (trade.symbol like 'IBM')
and (trade.symbol = 'IBM')
and (>>trade.volume > 10<<)
wrong number or types of arguments in call to gt. Check the spelling of the registered function. Also confirm that its call is correct and its parameters are of correct datatypes.>
<Dec 1, 2014 12:17:54 PM CST> <Emergency> <CQLServerTrace> <BEA-000000> <oracle.cep.exceptions.CEPException: wrong number or types of arguments in call to gt>
<Dec 1, 2014 12:17:54 PM CST> <Error> <CQLProcessor> <BEA-000000> <Failed to create statement [GetHighVolume].
Invalid statement: "select
trade.symbol, trade.volume from AdapterOutputChannel [now] as trade
where (trade.volume IS NOT NULL)
and (trade.symbol like 'IBM')
and (trade.symbol = 'IBM')
and (>>trade.volume > 10<<)"
Description: wrong number or types of arguments in call to gt
Cause: This error occurs when the named function call cannot be matched to any declaration for that function name. The function name might be misspelled, a parameter might have the wrong datatype, or the function declaration might be faulty
Action: Check the spelling of the registered function. Also confirm that its call is correct and its parameters are of correct datatypes.>
<Dec 1, 2014 12:17:55 PM CST> <Error> <Deployment> <BEA-2045016> <The application context "TradeReport" could not be started. Could not initialize component "<unknown>":
Invalid statement: "select
trade.symbol, trade.volume from AdapterOutputChannel [now] as trade
where (trade.volume IS NOT NULL)
and (trade.symbol like 'IBM')
and (trade.symbol = 'IBM')
and (>>trade.volume > 10<<)"
Description: wrong number or types of arguments in call to gt
Cause: This error occurs when the named function call cannot be matched to any declaration for that function name. The function name might be misspelled, a parameter might have the wrong datatype, or the function declaration might be faulty
Action: Check the spelling of the registered function. Also confirm that its call is correct and its parameters are of correct datatypes.>
i use OEP 11g. help me!
Answers
-
It seems like the semantic checks for comparison expression "trade.volume>10" is failing.
Kindly make sure that trade.volume is CQL native "int" type.
If problem is still coming after datatype checks, please share your EPN and configuration files with queries.