| quotes problem [message #79087] |
Tue, 23 April 2002 06:11  |
massa
Messages: 12
Registered: April 2002
|
Junior Member |
|
|
I am programing in asp and I am working on a program that make some querys on an oracle database.
The asp code works but not the querys and one paritcularly :
select * from people where User_Name='John';
The problem comes from the ' and it display this error :
ORA-12704: character set mismatch
I have tried the "", {}, [[]] and () but none of them worked so if someone has an idea, it could help.
Thanks
Christophe
|
|
|
|
| Re: quotes problem [message #79090 is a reply to message #79087] |
Tue, 23 April 2002 07:51  |
nik
Messages: 55
Registered: January 2002
|
Member |
|
|
christophe,
i have experieced similar in report 2.5,
AFTER p trigger, does not like single quotes when
lexical referencing.
To get around this however I used '' to represent '
try , it might work.
e.g. where name = ''Doe'', this does not work in SQL*plus but did from within reports 2.5
nik.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
