Oracle custom script say : Cannot fetch data: sql: expected 0 arguments, got 1.

[studero]

Hi all,

I have create a custom script to give the status of the request. But when I tried to use a parameter, the following error comes : Cannot fetch data: sql: expected 0 arguments, got 1..

My configuration and script:

The key of the new item :
- oracle.custom.query[{$ORACLE.CONNSTRING},{$ORACLE.USER},{$ORACLE.PASSW ORD},{$ORACLE.SERVICE},state_of_refresh,RPAP1_1166 55369_REFRESH]

The SQL script:
/* state_of_refresh.sql */
SELECT status
FROM sys.dba_scheduler_job_log
WHERE job_name = '&1'
ORDER BY log_date DESC FETCH FIRST 1 ROWS ONLY;

When I try to use the zabbix_get command on the Zabbix server, I see this error:
[root@svx-mon-02t ~]# zabbix_get -s srv_oracle -k oracle.custom.query[tcp://srv_oracle:1521,zabbix,zabbixpwd,co1191cl,stat e_of_refresh,PAP2]
ZBX_NOTSUPPORTED: Cannot fetch data: sql: expected 0 arguments, got 1.

If I run the same script without give the parameter, the result was correct.

I need help
Regards
Olivier