Saturday, November 25, 2006
Configure modplsql
MOD_PLSQL is an Apache (Web Server) extension module that allows one to create dynamic web pages from PL/SQL packages and stored procedures. It is ideal for developing fast and flexible applications that can run on the Internet or an Intranet. MOD_PLSQL was formerly called the Oracle PL/SQL Cartridge and OWA (Oracle Web Agent).
Usually is located in ORACLE_HOME/Apache/modplsql
When you try to connect to database you have to configure DAD - Database Access Descriptor.
Usually the configuration file is located in modplsql/conf/dads.conf
The main settings for DAD are:
http://your_web_server_where _you_configure_dad:port/xyz_test/test
Usually is located in ORACLE_HOME/Apache/modplsql
When you try to connect to database you have to configure DAD - Database Access Descriptor.
Usually the configuration file is located in modplsql/conf/dads.conf
The main settings for DAD are:
Testing connection and settings. In the databace you must create procedure:
<Location /xyz_test> #name you use in URL
SetHandler pls_handler
Order allow,deny
Allow from All
AllowOverride None
PlsqlDatabaseUsername userapp #user name
PlsqlDatabaseConnectString server:port:database_SID SIDFormat
PlsqlAuthenticationMode Basic #authentication type
PlsqlDocumentTablename Documents #Table name for uploading documents
PlsqlDocumentPath docs #name in URL to get documents from table
PlsqlDocumentProcedure documentdownload #procedure to show documents
PlsqlDefaultPage #default page
PlsqlDatabasePassword #password, it is optional
PlsqlNLSLanguage SLOVENIAN_SLOVENIA.UTF8 #NLS settings
</Location>
procedure test isand then call it from Internet browser like:
begin
htp.p('This is a test!');
end;
http://your_web_server_where _you_configure_dad:port/xyz_test/test
# posted by Domen Dolar @ 6:51 PM 
