Home » SQL & PL/SQL » SQL & PL/SQL » read hebrew from file (ORACLE linux )
read hebrew from file [message #621297] Tue, 12 August 2014 07:55 Go to next message
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 22 times)
Re: read hebrew from file [message #621316 is a reply to message #621297] Tue, 12 August 2014 09:14 Go to previous message
ThomasG
Messages: 3123
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.
Previous Topic: joining between 2 different dates ?
Next Topic: Find table with column
Goto Forum:
  


Current Time: Wed Dec 24 21:01:55 CST 2014

Total time taken to generate the page: 0.09821 seconds