• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

quote operator

 
Daniel Conner
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Marshal
Posts: 34851
369
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Daniel Conner
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Paul, no it is not.
 
Paul Campbell
Ranch Hand
Posts: 338
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic