netcool
asked on
ORA-22288: file or LOB operation FILEOPEN faile
I tried to execute the following sql script in Oracle satabase environment which hosted in Unix server, i hit the problem at below error message. Please advice what to do resolve it. I am not a unix person. Thank you.
Sql Script :
----
create or replace
java class
using bfile (runtime_classes,'Database StoredFunc tions.clas s');
/
commit;
create or replace
function generate_key( nSize IN number )
return varchar2
as language java
name 'com.lgc.dws.dt.util.Datab aseStoredF unctions.g enerateKey BySize( int ) return java.lang.String';
/
commit;
create or replace
function get_color_number( colorName IN varchar2 )
return number
as language java
name 'com.lgc.dws.dt.util.Datab aseStoredF unctions.g etColorNum ber( java.lang.String ) return int';
/
commit;
create or replace
function radians( degrees IN number )
return number
as language java
name 'com.lgc.dws.dt.util.Datab aseStoredF unctions.g etRadians( double ) return double';
/
commit;
create or replace
function get_yes_no( yesno IN number )
return varchar2
as language java
name 'com.lgc.dws.dt.util.Datab aseStoredF unctions.g etYesNo( java.lang.Integer ) return java.lang.String';
/
commit;
create or replace
function get_is_tight( istight IN number )
return varchar2
as language java
name 'com.lgc.dws.dt.util.Datab aseStoredF unctions.g etIsTight( int ) return java.lang.String';
/
commit;
create or replace
function get_well_coord_type( coordType IN number )
return number
as language java
name 'com.lgc.dws.dt.util.Datab aseStoredF unctions.g etWellCoor dType( int ) return int';
/
commit;
---------
Error message:
==========
ERROR at line 3:
ORA-22288: file or LOB operation FILEOPEN failed
No such file or directory
Sql Script :
----
create or replace
java class
using bfile (runtime_classes,'Database
/
commit;
create or replace
function generate_key( nSize IN number )
return varchar2
as language java
name 'com.lgc.dws.dt.util.Datab
/
commit;
create or replace
function get_color_number( colorName IN varchar2 )
return number
as language java
name 'com.lgc.dws.dt.util.Datab
/
commit;
create or replace
function radians( degrees IN number )
return number
as language java
name 'com.lgc.dws.dt.util.Datab
/
commit;
create or replace
function get_yes_no( yesno IN number )
return varchar2
as language java
name 'com.lgc.dws.dt.util.Datab
/
commit;
create or replace
function get_is_tight( istight IN number )
return varchar2
as language java
name 'com.lgc.dws.dt.util.Datab
/
commit;
create or replace
function get_well_coord_type( coordType IN number )
return number
as language java
name 'com.lgc.dws.dt.util.Datab
/
commit;
---------
Error message:
==========
ERROR at line 3:
ORA-22288: file or LOB operation FILEOPEN failed
No such file or directory
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
java class
using bfile (runtime_classes,'Database
/
do you have a directory object runtime_classes? if no, you have to create it first using :
create directory runtime_classes as '<your directory>';
first