On Fri, 09 Jun 2006 16:08:53 +1000, Ron Savage wrote: Hi Ron
OK. I got this working. I created a user thru the Oracle web interface http://127.0.0.1:8080/apex. This allows setting: o Username o Password & its expiry (Y/N) o Account status (Locked/Unlocked) o User privileges These are fixed: o Default Tablespace: USERS o Temporary Tablespace: TEMP Then I created an ODBC DSN. Now I can use DBI -> connect() to create and populate tables. Then, using uc Username as the schema name, I can get table_info(), column_info(), primary_key_info() and foreign_key_info() to work. Case closed. -- Ron Savage [EMAIL PROTECTED] http://savage.net.au/index.html
