| ERROR: (SQA03) [message #124845] |
Tue, 21 June 2005 16:04  |
najla2005
Messages: 28
Registered: June 2005
Location: tunisie
|
Junior Member |
|
|
hi
j’ai importé des données d’Access to express adminitrator :la variable dont j’ai voulu importé ses données est de type booléen comme en express administrator,cette variable est de type booléen.cette erreur s’affiche :
ERROR: (SQA03) The SQL data in column 1 of your fetch statement cannot be converted to type BOOLEAN.
thank you!
|
|
|
|
| Re: ERROR: (SQA03) [message #124883 is a reply to message #124845] |
Wed, 22 June 2005 01:13  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
This message seems to be in French, & is posted here in wrong forum. It should be posted in French forum.
The English translation of same is as below:
Source: http://ets.freetranslation.com/
Hi
I imported access data to expresses administrator: the variable of which I wanted imported its data is boolean type as in expresses administrator, this variable is boolean type. this error posts itself:
ERROR: (SQA03) The SQL data in column 1 of your fetch statement cannot be converted to typical BOOLEAN.
Thank you!
Regds
Girish
|
|
|
|
|
|
| Re: ERROR: (SQA03) [message #125109 is a reply to message #124970] |
Thu, 23 June 2005 06:12 |
Maaher
Messages: 6963
Registered: December 2001
|
Senior Member |
|
|
Have you set a different NLS_LANG on your client than on the server?
If so, take a look at MetaLink Note:166617.1.
BOOLEAN is not a valid SQL datatype, so perhaps that's your problem.
MHE
|
|
|
|
| Re: ERROR: (SQA03) [message #125302 is a reply to message #125109] |
Fri, 24 June 2005 05:38 |
najla2005
Messages: 28
Registered: June 2005
Location: tunisie
|
Junior Member |
|
|
hi
thank you for your help.
i want to set " batch job manager server " but i don't know when i find it .Please help if you can and thank for your comprehension in advance.
bye
|
|
|
|
|
|
|
|
| Re: ERROR: (SQA03) [message #125394 is a reply to message #125306] |
Fri, 24 June 2005 16:36 |
Maaher
Messages: 6963
Registered: December 2001
|
Senior Member |
|
|
The note advises to set the client's language to the same NLS settings as the server. I cannot disclose MetaLink content just like that. It's Oracle official Support site and it's not for free.
To change NLS settings on a Wintel client:
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/NLS_LANG: change the value to the same as the database.
MHE
|
|
|
|
|
|
| to maaher [message #125908 is a reply to message #125109] |
Wed, 29 June 2005 19:13 |
najla2005
Messages: 28
Registered: June 2005
Location: tunisie
|
Junior Member |
|
|
hi Mr Maaher you are fine?
j'ai voulu installer oracle express 6.3.2 mais message apparait
"the java run time environment was not found at bin\jrew.exe.HENCE the oracle universal installer can not be run.Please visit
http://www.javasoft.com and instal jre version 1.1.7 OR HIGHER AND TRRY."
mais lorsque j'ai insatllé le jre dans ma poste toujours le mêe message d'erreur.
please maher répond moi.merci
|
|
|
|
| Re: to maaher [message #125991 is a reply to message #125908] |
Thu, 30 June 2005 06:58 |
Maaher
Messages: 6963
Registered: December 2001
|
Senior Member |
|
|
Some suggestions:
from lazydba: install the JRE at it's default location if you didn't.
copy the installation disk(s) to the hard drive and change the oraparam.ini file.
In there you'll find a line:
JRE_LOCATION="....."
Change the value to: "the_path_of_your_first_disk/Stage/Components/oracle.swd.jre/1.1.7.30/1/DataFiles/Expanded/jre"
Verify the version number. This comes from dbForums.
MHE
|
|
|
|
|
|
| jre [message #126400 is a reply to message #125991] |
Mon, 04 July 2005 04:56 |
najla2005
Messages: 28
Registered: June 2005
Location: tunisie
|
Junior Member |
|
|
hi
j'ai essayé la solution que vous m'avez envoyé concernant l'installation d'oracle express ou le problème etait
"The Java Run Time Environmentwas not found at the_path_of_your_first_disk/stage/components/oracle.swd.jre/1.1.7.30/1/data files/Expanded/jre/win32/bin/jrew.exe.Hence, The Oracle Universal Installer cannot be run .Please visit http://www.javasoft.com and install JRE version 1.1.7 or higher and try again. "mais j'ai pas trouvé une solution et le meme essage apparait pourtant j'ai installé aussi jre 1.1.8.
please help and thank you
best regards
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
