wood burning stoves 2.0*
The moose likes Oracle/OAS and the fly likes quote operator Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "quote operator" Watch "quote operator" New topic
Author

quote operator

Daniel Conner
Ranch Hand

Joined: Jan 25, 2007
Posts: 47
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 29245
    
139

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?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Daniel Conner
Ranch Hand

Joined: Jan 25, 2007
Posts: 47
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

Joined: Oct 06, 2007
Posts: 338
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

Joined: Jan 25, 2007
Posts: 47
Paul, no it is not.
Paul Campbell
Ranch Hand

Joined: Oct 06, 2007
Posts: 338
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: quote operator
 
Similar Threads
Questions about Oracle OCP 10g DBA
Hibernate: Accessing multiple databases within same transaction
Not able to store ukrainian characters in Oracle 10g database
Regarding Exam 1Z0-001(OCP)
Not authenticating the user