Hi, I had the same problem. I helped me out with a managed Custom Action. The Custom Action is written in C#, uses the Oracle.DataAccess.Client namespace, transactions, commands etc ...
Advantages: - full control over the DB-process (transaction handling, exception/error handling, script preparation/manipulation, parameters, detailed logging, etc.) Disadvantages: - .Net Framework has to be installed on target machine first - Oracle Data Access Components (ODAC) have to be installed on target machine first - "exotic solution" outside the regular standard of the MSI Another solution would be to write a Custom Action that starts the commandline tool SQL*PLUS in silent mode and passes logon and script I think there's even already a built-in Custom Action for that ( "LaunchFile" ) - see the notepad example in the Wix-Tutorial (Lesson 3 - "Events and Actions", chapter 3.2 "Extra Actions") - http://www.tramontana.co.hu/wix/lesson3.php#3.2 Is there an "official" way to do this (apply oracle scripts, pass parameters to it etc...)? That would make me quite more happy then using my Custom Action and so including an "exotic solution" in my MSI. Greets, Bernd -----Original Message----- From: ryan robin [mailto:ryanro...@gmail.com] Sent: Freitag, 22. Oktober 2010 05:36 To: wix-users@lists.sourceforge.net Subject: [WiX-users] [Wix-user] Run Oracle script Hi Wixers, I'm quiet new to Wix. I have a OracleXE 10g. Is there any way to run Oracle script to create/update some tables with existing Oracle user (as it should not create new user)? It seems that Wix doesn't support Oracle at the moment, right? Thanks, Ryan ---------------------------------------------------------------------------- -- Nokia and AT&T present the 2010 Calling All Innovators-North America contest Create new apps & games for the Nokia N8 for consumers in U.S. and Canada $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store http://p.sf.net/sfu/nokia-dev2dev _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ Nokia and AT&T present the 2010 Calling All Innovators-North America contest Create new apps & games for the Nokia N8 for consumers in U.S. and Canada $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store http://p.sf.net/sfu/nokia-dev2dev _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
