wrong number or types of arguments in call to gt

user2177532

<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!

Sandeep Bishnoi-Oracle

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.