Have you experimented with loading PLDoc into an Oracle instance and having it run from there? The advantage of this would be the ability to schedule it to run through Oracle's DBMS_Job mechanism without having to include Oracle Username/Password strings anywhere.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'd prefer something that simply generated on demand. Even Oracle's core RDBMS bundles Apache these days. You need iAS to get mod_plsql, but there's still PHP which Oracle seem to be taking seriously these days. Depending on the overhead/demand, of course.
But even as a static web page generator, the security model for Java within the Oracle RDBMS engine is much the same as the "normal" one. It could be configured to write to the file system much as it currently does.
(Indeed, file I/O via the Java layer provides much more granular control of who can do what to which directory than the alternatives, at least prior to 9iR2. DBMS_LOB via DIRECTORYs is only good for reading. And UTL_FILE prior to 9iR2 uses directories specified via an instance parameter, and you can't control who can use which directory.)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
If you want to use pldoc there, just do it.
I don't think there are any changes required.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2004-01-13
Oracle RDBMS has included mod_plsql atleast since 8.1.7. You don't need iAS for that. Just fire up Apache, configure database access descriptors (DAD) and start executing plsql from your web browser. For plsql web-applications, check out the owa- and htp-packages.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Have you experimented with loading PLDoc into an Oracle instance and having it run from there? The advantage of this would be the ability to schedule it to run through Oracle's DBMS_Job mechanism without having to include Oracle Username/Password strings anywhere.
Hmm, but where would you put the resulting HTML files ?
Could it be done realtime? (a mod_plsql set of HTML pages that is always the latest documentation?)
Why not.
I hope somebody will do it :)
I'd prefer something that simply generated on demand. Even Oracle's core RDBMS bundles Apache these days. You need iAS to get mod_plsql, but there's still PHP which Oracle seem to be taking seriously these days. Depending on the overhead/demand, of course.
But even as a static web page generator, the security model for Java within the Oracle RDBMS engine is much the same as the "normal" one. It could be configured to write to the file system much as it currently does.
(Indeed, file I/O via the Java layer provides much more granular control of who can do what to which directory than the alternatives, at least prior to 9iR2. DBMS_LOB via DIRECTORYs is only good for reading. And UTL_FILE prior to 9iR2 uses directories specified via an instance parameter, and you can't control who can use which directory.)
If you want to use pldoc there, just do it.
I don't think there are any changes required.
Oracle RDBMS has included mod_plsql atleast since 8.1.7. You don't need iAS for that. Just fire up Apache, configure database access descriptors (DAD) and start executing plsql from your web browser. For plsql web-applications, check out the owa- and htp-packages.