I have a problem. I want to call my java class and method from Oracle 10g PL/SQL. But I don't know how I can do this. Simply I do the following application.
In server side PL/SQL read data from forms and moves this data to the file.
In java class, the java method opens the file with given path and file name. Create excell file by using hssfworkbook. Then moved the data in the file to the hssfworkbook. After that the methods returns hssfworkbook.
The PL/SQL part I want to call this method and get the result of hssfworkbook. But I don't know how i can call java class and method from oracle 10g PL/SQL.
Does anyone help me on this issue?
Thank you very much