| Using bfiles, oracle 8.1.7 and SUSE-Linux [message #375013] |
Thu, 19 July 2001 00:53 |
Siegfried Fechner
Messages: 1
Registered: July 2001
|
Junior Member |
|
|
Problem: Using bfiles, oracle 8.1.7 and SUSE-Linux:
Contents: ORA-22288, ORA-06512, bfile, oracle 8.1.7, linux(SUSE 7.0)
--------------------------------------------------------------------
directory '/daten_extern' and file 'demo_txt_1.txt' exist;
SQLPLUS-display;
SQL> create or replace directory "datei" as '/daten_extern';
SQL> grant read on directory "datei" to public;
SQL> select DIRECTORY_NAME||'|'||DIRECTORY_PATH from all_directories;
DIRECTORY_NAME||'|'||DIRECTORY_PATH
-------------------------------------------------------
datei|/daten_extern
SQL> desc lobdemo;
Name Null? Type
----------------------------------------- -------- -------
KEY NOT NULL NUMBER
CLOB_COL CLOB
BLOB_COL BLOB
BFILE_COL BINARY FILE LOB
BFILE_TYPE VARCHAR2(10)
SQL> INSERT INTO lobdemo (key, bfile_col, bfile_type) VALUES (1, BFILENAME('datei', 'demo_txt_1.txt'), 'ansi');
SQL> select key, bfile_type, dbms_lob.getlength(bfile_col) from lobdemo;
select key, bfile_type, dbms_lob.getlength(bfile_col) from lobdemo
*
ERROR at line 1:
ORA-22288: file or LOB operation GETLENGTH failed
Datei oder Verzeichnis nicht gefunden
ORA-06512: at "SYS.DBMS_LOB", line 518
ORA-06512: at line 1
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
