Sql Script Job Fails In The Console With Invalid Property
Last updated on MAY 01, 2015
Applies to:Enterprise Manager for Oracle Database - Version 10.1.0.2 to 220.127.116.11 [Release 10.1 to 11.2]
Information in this document applies to any platform.
Any SQL Script job fails when a wildcard (%) is used in the in the SQL command.
Invalid Property - The following property is incorrectly specified. Please
verify that property names are spelled correctly, are in the proper case and
are enclosed in percent signs. %rowcount < 1000000 then
Example of script:
where createdttm < (sysdate - 2)
and rownum <= 1000000;
if sql%rowcount < 1000000
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms