Michael, thanks for the fix for the prepare statement, this helped. Oracle now creates the tables.
There is a minor issue, if ORACLE_HOME is not set, the DBI module fails to get a handle on the database and dies with an error that is not intuitive to the user. A more user friendly error message would be great, but this is low priority... DEBUG: OpenCA::DBI->errno: returning local errorcode 11111 OpenCA: General error trapped 700: The compilation of the command cmdGenDB faile d. Can't call method "prepare" on an undefined value at /home/cmn090/lib/perl5/O penCA/DBI.pm line 2520.<br> Compilation failed in require at ./openca_start line 62. Concerning environment variables I am using the following section in DBI.conf.template now and it works without externally setting the environment. Not sure if this 'number 1' thing is OK, though. You may want to include the following in the database configuration template to make modification easier for new installs. <environment> [...] <vendor> <type>Oracle</type> <number>1</number> <option> <name>ORACLE_HOME</name> <value>/opt/oracle/OraHome</value> </option> </vendor> have a nice weekend, Martin ------------------------------------------------------- This SF.Net email is sponsored by OSTG. Have you noticed the changes on Linux.com, ITManagersJournal and NewsForge in the past few weeks? Now, one more big change to announce. We are now OSTG- Open Source Technology Group. Come see the changes on the new OSTG site. www.ostg.com _______________________________________________ OpenCA-Devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/openca-devel