There is a command in oracle to run web reports callede RUN_REPORT.
Can we call the command or program containing the command from Java program using JNI???
posted 10 years ago
Yes you can. First you need to build a plain java class that uses JDBC to run the RUN_REPORT command. If your driver doesn�t support this command, then you have to build a stored procedure that runs the command. Finally your java application will call that stored procedure. After you tested your class you�ll build an RMI object (this could be an EJB as well) that uses your previous class as a proxy. Finally you have to bind the RMI object to your JNDI tree. Now your clients can lookup the object into the JNDI and invoke the method for running the report in oracle. And only for my curiosity: why do you want to do this? Regards.