Home » Non-English Forums » French » ERROR: (SQA03)
ERROR: (SQA03) [message #124845] Tue, 21 June 2005 16:04 Go to next message
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 Go to previous messageGo to next message
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 #124970 is a reply to message #124883] Wed, 22 June 2005 10:08 Go to previous messageGo to next message
najla2005
Messages: 28
Registered: June 2005
Location: tunisie
Junior Member
thank you for this information and can you help me please concerning "the error sqa03"
Re: ERROR: (SQA03) [message #125109 is a reply to message #124970] Thu, 23 June 2005 06:12 Go to previous messageGo to next message
Maaher
Messages: 7065
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 Go to previous messageGo to next message
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 #125304 is a reply to message #125109] Fri, 24 June 2005 05:58 Go to previous messageGo to next message
najla2005
Messages: 28
Registered: June 2005
Location: tunisie
Junior Member
hi
i'm not registrated in metalink that's why i can't acceed to contenu .
please help Maaher if you can.
icon13.gif  Re: ERROR: (SQA03) [message #125306 is a reply to message #125109] Fri, 24 June 2005 06:15 Go to previous messageGo to next message
najla2005
Messages: 28
Registered: June 2005
Location: tunisie
Junior Member

hi
i don't set NLS_LANG.
I WANTto download it please help.
thank you. Embarassed
Re: ERROR: (SQA03) [message #125394 is a reply to message #125306] Fri, 24 June 2005 16:36 Go to previous messageGo to next message
Maaher
Messages: 7065
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
icon7.gif  Re: ERROR: (SQA03) [message #125435 is a reply to message #125394] Sat, 25 June 2005 05:24 Go to previous messageGo to next message
najla2005
Messages: 28
Registered: June 2005
Location: tunisie
Junior Member
hi
I thank you infinitely to have me to reply.
I want to download the "batch job to manage server" to do the schedling of a program in "express administrator" and I count on your help.
to maaher [message #125908 is a reply to message #125109] Wed, 29 June 2005 19:13 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Maaher
Messages: 7065
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
Re: to maaher [message #126148 is a reply to message #125991] Fri, 01 July 2005 05:03 Go to previous messageGo to next message
najla2005
Messages: 28
Registered: June 2005
Location: tunisie
Junior Member
je vous remercie infiniment de m'avoir répondu et me donner une solution que je vais essayer. Razz
jre [message #126400 is a reply to message #125991] Mon, 04 July 2005 04:56 Go to previous message
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

Previous Topic: schedule
Next Topic: determinate the number of a day
Goto Forum:
  


Current Time: Thu Mar 28 15:13:40 CDT 2024