Re: help!! how to call pl/sql anonymous block from java?

In article <pan.2014.02.18.16.09.10_at_gmail.com>, gogala.mladen_at_gmail.com says...
>
> On Tue, 18 Feb 2014 05:41:05 -0800, abhishek.anne wrote:
>
> >> // register the output parameter
> >> oracs.registerOutParameter(1,OracleTypes.CURSOR);
> >
> >
> > Hello,
> >
> > How could use same for SQL Server.
>
> You cannot use PL/SQL in SQL Server, unless I'm very much mistaken. The only two
> databases that support PL/SQL are Oracle and DB2. For those surprised by the
> latter database, the documentation is here:
>
> http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.db2.luw.apdv.plsql.doc%2Fdoc%2Fc0053607.html
> http://pic.dhe.ibm.com/infocenter/idmhelp/ds-v2r2/index.jsp?topic=%2Fcom.ibm.datatools.routines.plsql.doc%2Ftopics%2Ftplsqlrun.html
>

I was interested to learn of this capability and was wondering about the licensing costs - wondering if DB2 would work out cheaper.

Sort of a non-issue once I releaised there are some key data types that are not supported in the DB2 implementation (IIRC XMLTYPE being one of them).

-- 
jeremy