OraFAQ Forum: SQL & PL/SQL » read hebrew from file

Home » SQL & PL/SQL » SQL & PL/SQL » read hebrew from file (ORACLE linux )

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

read hebrew from file [message #621297]

Tue, 12 August 2014 07:55

einatmilo
Messages: 1
Registered: August 2014
Location: israel

Junior Member

hi,
i am trying to load a file from a linux server into oracl db 11.2

i load the file with a shell
export ORACLE_HOME=/OracleTools/11.2;
export NLS_LANG=AMERICAN_AMERICA.IW8MSWIN1255;
cd /OracleTools/11.2;
/OracleTools/11.2/bin/sqlplus -s opc_op/opc_op@omdb << EOF > log.txt

DECLARE
v NUMBER ;
x VARCHAR2(100);
BEGIN
opc_op.LOADFILE_PR;
commit;

END;
/
EXIT
EOF

the code works fine with the file contain english
when i change it into hebrew i get ORA-29284

there is no problem insert hebrew from my oracleClient

10X for the help!

Attachment: loadfile.txt
(Size: 1.02KB, Downloaded 1007 times)

Report message to a moderator

Re: read hebrew from file [message #621316 is a reply to message #621297]

Tue, 12 August 2014 09:14

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

~ $ oerr ORA 29284
29284, 00000, "file read error"
// *Cause:  An attempt to read from a file failed.
// *Action: Verify that the file exists, and that it is accessible, and
//          that it is open in read mode.

The file you want to load doesn't exist, according to the error.

Report message to a moderator

Previous Topic:	joining between 2 different dates ?
Next Topic:	Find table with column

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 15:27:31 CDT 2024