Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing a % sign in a grid task

Status
Not open for further replies.

Cretin

Technical User
Jan 2, 2003
194
US
Is it possible to pass the chr function with the ascii value of % in a grid task command. Grid considers it a wildcard.

Cretin
 
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.
 
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
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top