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

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 18 Feb 2014 17:49:30 +0000 (UTC)
Message-ID: <pan.2014.02.18.17.49.29_at_gmail.com>


On Tue, 18 Feb 2014 16:51:15 +0000, Jeremy wrote:

> 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).

Yes, XMLType is not implemented in the DB2 version PL/SQL, only the basic types are. DB2 has its own XML mechanism and interface but it's not PL/SQL based like Oracle's. Still, that does make application porting much easier than porting applications to SQL Server.

-- 
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com
Received on Tue Feb 18 2014 - 18:49:30 CET

Original text of this message