Hi Mladen
We started evaluating MTS and JDBC Thin Driver (newest version for JDK 1.4,
running on Win2k against a test db on win2k, test db is oracle 9.2.0.3.0). I
never used SRVR=DEDICATED. I have a dispatcher running on port 5000 and a
listener on port 1521.
The only thing I do to direct the
Hi Regis
That's basically right. As I just posted, we use MTS for development, so
that not every developer starts up a local connection pool on their
workstation and we also don't end up with too many dedicated server
processes.
But I think you're right saying that MTS and application side
Hi Antje
Eventhough I never migrated Sybase (or SQL Server) code (JDBC/Java) to
Oracle,
maybe that helps anyway:
In Transact SQL, you can actually return data from an anonymous block,
that's correct. An equivalent to do this in PL/SQL might be the use of
OUT parameters within stored
Hi Richard
You can do that. But I think it is recommandable to wrap up the PL/SQL and
put it into packages. This way, your code is much better organized than
having anonymous blocks throughout your Java code.
Regards,
Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298