OraFAQ Forum: French » ERROR: (SQA03)

Home » Non-English Forums » French » ERROR: (SQA03)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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!

Report message to a moderator

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

Report message to a moderator

Re: ERROR: (SQA03) [message #124970 is a reply to message #124883]

Wed, 22 June 2005 10:08

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"

Report message to a moderator

Re: ERROR: (SQA03) [message #125109 is a reply to message #124970]

Thu, 23 June 2005 06:12

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

Report message to a moderator

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

Report message to a moderator

Re: ERROR: (SQA03) [message #125304 is a reply to message #125109]

Fri, 24 June 2005 05:58

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.

Report message to a moderator

Re: ERROR: (SQA03) [message #125306 is a reply to message #125109]

Fri, 24 June 2005 06:15

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

Report message to a moderator

Re: ERROR: (SQA03) [message #125394 is a reply to message #125306]

Fri, 24 June 2005 16:36

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

Report message to a moderator

Re: ERROR: (SQA03) [message #125435 is a reply to message #125394]

Sat, 25 June 2005 05:24

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.

Report message to a moderator

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

Report message to a moderator

Re: to maaher [message #125991 is a reply to message #125908]

Thu, 30 June 2005 06:58

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

Report message to a moderator

Re: to maaher [message #126148 is a reply to message #125991]

Fri, 01 July 2005 05:03

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

Report message to a moderator

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 15 13:26:42 CDT 2026