I have written a translation object in
java that takes a $en_var in and returns its path.
What I need to do is call that object from a PL/SQL store procedure. All the examples I have seen treat the store procedure as a wrapper around the java object.
But in my store procedure calling the object is only one part of the procedures role:
The store procedure code is :
CREATE OR REPLACE PROCEDURE WRITE_TO_FILE(in_file_name IN VARCHAR, in_en_var IN VARCHAR)
file_handleUTL_FILE.FILE_TYPE;
file_location VARCHAR2(50)
BEGIN
*************************************************************
I need to be able to call the javaobject translation here
file_location = translation.translatePath(in_en_var)
*****************************************************************
file_handle := UTL_FILE.FOPEN(file_location, in_file_name, 'w');
dbms_output.put_line ('input file name opened file name' ||in_file_name ||'-->' ||in_file_location);
UTL_FILE.put_line(file_handle,'Hello Tony);
UTL_FILE.FCLOSE(file_handle);
END WRITE_TO_FILE;
/
I call the java class method translatePath with a
string the en_var which returns the path as a string which is then passed as a parameter to UTL_FILE.FOPEN.
Thanks for any help
Tony