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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

複数の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

843807
I don't know the exact cause of the problem, but as a -not so nice but it works- solution, I propose to add the following line right before the first c.repaint() call:
c.add(new JLabel());
843807
This may sound silly but are you using a layout manager? If not, why not? Setting positions is difficult and keeping the controls in the right place will be difficult. When you use a layout manager, you can programmatically "lock" the labels. Using BorderLayouts and GridBagLayouts are terrific. Check out this link, it helped me a lot.

http://developer.java.sun.com/developer/onlineTraining/GUI/AWTLayoutMgr/shortcourse.html

Just remember that you should decide how you want the labels to behave (should they resize and move or be fixed) and pick the layout that matches that behavior. Create a JPanel, set that layout and then add the JLabels...
843807
I added a null layout manager and everything stuck. One line of code. Ha ha that article on layout managers was good thanks.
1 - 3
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,745 views