Passing a % sign in a grid task

Question

Passing a % sign in a grid task

Cretin (TechnicalUser)

(OP)

11 Jun 13 08:12

Is it possible to pass the chr function with the ascii value of % in a grid task command. Grid considers it a wildcard.

Cretin

SantaMufasa (TechnicalUser) · Answer 1 · 2013-06-13 01:32:09

Could you please post what you've tried already, along with the error message?

santa Mufasa
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel."

Cretin (TechnicalUser) · Answer 2 · 2013-06-13 09:32:23

JOB_ADHOC database.schema JOB_ADHOC.R099_MAIN_PRC 201304,[0100],[test],[\%]

ERROR at line 1:
ORA-20099: ORA-20005: Error in r025_validate_input_prc :ORA-20005: JOB did
not complete successfully for cycle year month: 201304
ORA-06512: at "schema.JOB_ADHOC", line 1085
ORA-06512: at line 1

Cretin

SantaMufasa (TechnicalUser) · Answer 3 · 2013-06-13 12:32:36

Sorry Cretin, unless we can see the underlying SQL that actually uses the "%", I don't know how helpful we (at least I) can be.

santa Mufasa
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel."

Come Join Us!

Posting Guidelines

Jobs

Passing a % sign in a grid task