Regular Expression for notepad++ to find to_timestamp in oracle dump

Data dump from oracle contained to_timestamp entries which do not work when used in MS SQL Server.

The regular expression to find these entries in notepad++, to change them for MS SQL:
(non-greedy search of .*? did not work but this does)

to_timestamp\(([^(\))]*)\)

References:

Oracle, hibernate, jdbc errors

Using Oracle 9i with hibernate on Websphere was giving consistent but unpredictable errors when writing to the database.

Patches for oracle on Win2003 – oracle patch v9.2.0.3 and the jdbc driver that came with it also did not help. (the dates on the ojdbc-jars with 9i were in 2002 and 2003)

Using the jdbc driver that came with the Oracle 10g express as the oracle driver in Websphere (but still using Oracle 9i, just the jdbc jar is the one from 10g) fixed the issues.

>>>>ojdbc14.jar
Manifest-Version: 1.0
Specification-Title:    Oracle JDBC driver classes for use with JDK14
Sealed: true
Created-By: 1.4.2_08 (Sun Microsystems Inc.)
Implementation-Title:   ojdbc14.jar
Specification-Vendor:   Oracle Corporation
Specification-Version:  Oracle JDBC Driver version - "10.2.0.1.0XE"
Implementation-Version: Oracle JDBC Driver version - "10.2.0.1.0XE"
Implementation-Vendor:  Oracle Corporation
Implementation-Time:    Wed Jan 25 01:28:31 2006