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 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
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.comReceived on Tue Feb 18 2014 - 18:49:30 CET