Forum:

Oracle/OAS

quote operator

Ranch Hand

Posts: 47

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

There are different Oracle 10g databases that I work on. One one particular Oracle 10g database, the following using the quote operator works and on the other one, it doesn't. I was wondering if anyone had any idea why it work on one Oracle 10g database but not on the other? Thanks.

BTW... When I say quote operator... I mean:

Select q'#Oracle's quote operator is super awesome#' from dual;

Jeanne Boyarsky

author & internet detective

Posts: 42173

937

I like...

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Daniel Conner wrote:on the other one, it doesn't.

Does it give you an error or fail silently?

Have you checked if escaping is off in one database?

[OCP 21 book] | [OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2

Java 8 (verified skill)
Skill verified by Jeanne Boyarsky

JUnit 5 (verified skill)
Skill verified by Jeanne Boyarsky

Daniel Conner

Ranch Hand

Posts: 47

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

It doesn't fail silently, it gives an error. I haven't checked to see if escaping is turned off or on. How would I do so? Thanks.

Daniel

Paul Campbell

Ranch Hand

Posts: 338

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Daniel Conner wrote:It doesn't fail silently, it gives an error. I haven't checked to see if escaping is turned off or on. How would I do so? Thanks.

Daniel

Daniel,

Is your oracle home the same in both instances?

Daniel Conner

Ranch Hand

Posts: 47

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Paul, no it is not.

Paul Campbell

Ranch Hand

Posts: 338

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Daniel Conner wrote:Paul, no it is not.

Check and see if the one that fails is pointing to a pre-10 client... that is normally the source of this type of problem.

Those who dance are thought mad by those who hear not the music. This tiny ad plays the bagpipes:

Clean our rivers and oceans from home

https://www.kickstarter.com/projects/paulwheaton/willow-feeders