Execute DBMS script fails with invalid parameter type

First of all, I'm new to 24/7 scheduler so maybe this is very obvious...

I'm trying to execute a DBMS script on an Oracle database (To update the statistics daily). But when I execute Scheduler throws an error. It mentions that the "stored procedure parameter of type 'BOOLEAN' is invalid for 'ESTIMATE_PERCENT'" when executing:

DIM analyse_sql,string
DIM rows, number

ConcatEx "Execute dbms_stats.gather_schema_stats (OWNNAME => 'owner', OPTIONS => 'GATHER AUTO', estimate_percent => dbms_stats.auto_sample_size);", analyse_sql

DatabaseConnect( "schema_owner" )
DatabaseExecute( analyse_sql, rows)
DatabaseDisconnect

The database connection is working fine with other tasks... Can anybody explain to me what I'm doing wrong?

Also, the script part is working fine when I execute it in a SQL editor tool (Golden).

EXECUTE is not a PL/SQL statement in Oracle, it is SQL extension in which case you cannot use PL/SQL calling notation. The command you want is CALL. Secondary, when referring to PL/SQL elements such as BOOLEAN data types in your SQL code you should use PL/SQL compatible syntax. What you want to execute is below

	Code:
	BEGIN CALL dbms_stats.gather_schema_stats (OWNNAME => 'owner', OPTIONS => 'GATHER AUTO', estimate_percent => dbms_stats.auto_sample_size); END;

and just in case.... for a simple task like that you don't need to use JAL and complicated script type jobs. Instead, choose database type for this job and paste the above SQL into the job SQL text box. Select connection from the drop-down and you are done. As simple as that.

Hope this helps.

Thanks a bunch.

The solution was to just leave out the Call part in your solution.

	Code:
	BEGIN dbms_stats.gather_schema_stats (OWNNAME => 'owner', OPTIONS => 'GATHER AUTO', estimate_percent => dbms_stats.auto_sample_size); END;

Also, the task is a little bit more complicated than just executing this one statement, but thanks for the tip.

Thanks again!