Ahmed Bin S wrote:Two more points:
1) That isn't PL/SQL that you executed - that is plain ANSI SQL.
2) The convention is to start variable names with a lowercase, so you might want to change OraConnection to oraConnection.
Thanks, that worked well, I am falling for every thing in the book, trying to come back up to speed.
And yes, that's indeed plain ANSI SQL, but I do have reams of old PL/SQL and TSQL though
I don't think that's going to work on SQL Server though, I don't think the ojdbs understands Class.forname(), this is what I have to do next.