Solved

ORA-22288: file or LOB operation FILEOPEN faile

Posted on 2006-07-15
2
2,474 Views
Last Modified: 2007-12-19
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,'DatabaseStoredFunctions.class');
/
commit;

create or replace
 function generate_key( nSize IN number )
 return varchar2
 as language java
 name 'com.lgc.dws.dt.util.DatabaseStoredFunctions.generateKeyBySize( 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.DatabaseStoredFunctions.getColorNumber( 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.DatabaseStoredFunctions.getRadians( 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.DatabaseStoredFunctions.getYesNo( 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.DatabaseStoredFunctions.getIsTight( 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.DatabaseStoredFunctions.getWellCoordType( int ) return int';
/
commit;
---------

Error message:
==========
ERROR at line 3:
ORA-22288: file or LOB operation FILEOPEN failed
No such file or directory
0
Comment
Question by:netcool
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 19

Expert Comment

by:actonwang
ID: 17114109
>>create or replace
 java class
 using bfile (runtime_classes,'DatabaseStoredFunctions.class');
/


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

0
 
LVL 19

Accepted Solution

by:
actonwang earned 125 total points
ID: 17114110
also make sure if there is DatabaseStoredFunctions.class file under the directory.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question