Skip to Main Content

Japanese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

複数のselect結果を出力するには?

852764Apr 4 2011 — edited Apr 14 2011
こんにちは 教えてください

従来SYBASEで開発をしており
最近Oracle(11g - r2)に移行しようと考えています。

そこで問題になっているのが
SYBASEでは ストアドプロシジャにて

create proc get_startup
as
--マスタXXX読み込み
 select aaa,bbb from XXX
--マスタYYY読み込み 
 select * from YYY
--マスタZZZ読み込み
 select NNN,PPP from ZZZ where flag = '1'

みたいな形で startup時に読み込むマスタ群を 一つのSPにまとめて管理しているのですが
ORACLEではこういうことは出来ないのでしょうか???

oracleのREF CURSORで outputできそうなんですが
それだとJDBCで受け取るのが非常に難しく 他にいい方法がないか
よろしければ 教えて頂けないでしょうか?

よろしくお願いします

Edited by: 849761 on 2011/04/04 18:22

Comments

522770
Hi Sascha,

DB XML has no current plans to support XInclude. Could you use an external XInclude processor to assemble your documents before they are put into DB XML?

John
473555
Could you use an external XInclude processor to assemble your documents before they are put into DB XML?
That would defeat the purpose I had in mind - storing a document once and then referencing it from multiple other documents. As I said I think that's pretty easy to implement using XQuery.

I just wanted to ask if XInclude was somewhere on the horizon.
Gmfeinberg-Oracle
Sascha,

The upcoming 2.3 release has support for classes that can be used
to "pull" result content as a stream of events, which could
allow your application to efficiently recognize, and use Xinclude
attributes.

Regards,

George
473555
Hi,
The upcoming 2.3 release has support for classes that
can be used to "pull" result content as a stream of events.
Sounds great - I think I already have some ideas of how to use that. :-)
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 12 2011
Added on Apr 4 2011
12 comments
6,779 views