Wednesday, April 11, 2007

OC4J or Java Stored Procedures

I came across the following nice story and think i shoud highlight this on my blog:
http://kristianjones.blogspot.com/2007/03/oc4j-or-java-stored-procedures.html

Enjoy, Kuassi

7 comments:

mathewbutler said...

Kuassi,

Very briefly, does 10.2.0.3 support the publishing of non-static Java methods to PL/SQL?

I found p131 of your book confusing on this point.

Regards,

Kuassi Mensah said...

Mathew,

Thanks for your feedback and question.
I think you are referring to
the section on Object Type Call Spec.
It says:

(i) Top-level Call Spec and PL/SQL Packaged Call Spec can only publish
public static Java methods.

(ii) Object Type Call Spec can publish member methods of object
types that are either public static methods using the STATIC keyword or nonstatic methods (instance methods) using the MEMBER keyword.

Is this the confusing section?

I am on the road and only have access to draft soft version of the book so i might not be reading the same page.

Regards, KUassi

mathewbutler said...

Hi Kuassi,

Yes, that is the reference. In ii), it wasn't clear to me whether you were refering to SQL object types or Java classes when refering to public static methods and nonstatic methods.

Does 10.2.0.3 support the publishing of non-static Java methods to PL/SQL?

I don't believe so. Do you agree? Any idea why there might be this restriction?

Like the book - the subject fills a big hole in the market place.

Regards,

Kuassi Mensah said...

Mathew,

public statis method refers to Java.

Regarding the publishing of non-static methods, in 10.2.0.3 and even 11g, you will ned to turn this into a public static metod (just wrap it with a public static envelop); this is of course in the case of top-level call spec.

Glad the book was abit helpful.

Regards, Kuassi

mathewbutler said...

Thanks Kuassi

Anonymous said...

(法新社a倫敦二B十WE四日電) 「情色二零零七」情趣產品大產自二十三日起在倫敦的肯辛頓奧林匹亞展覽館舉成人電影行,倫敦成人電影人擺脫對性的保守態度踴躍參觀,許多穿皮衣與塑膠緊身衣的好色之徒擠進這項成人網站世界規模最大的成人生活展,估計三天展期可吸引八萬多好奇民眾參觀。色情

活動計畫負責人a片下載米里根承諾:「要搞浪漫、誘惑人、玩虐待,你渴望的我們都有。」
成人網站
他說:「時髦的設計成人影片與華麗女裝,從吊飾到束腹到真人大小的雕塑,是我們由a片今年展出的數千件產品精av選出的一部分,A片下載參展產品還包括時尚服飾、貼身女用內在美、鞋子、珠寶、玩具、影片、藝術av女優成人影片圖書及遊戲,更不要說性愛輔具及馬術裝備。」
色情
參觀民眾遊覽情色電影A片百五十多個攤位,有性感服AV裝、玩具a片及情色食品,迎合各種品味。

情色大舞台上表演的是美國野蠻搖滾歌手瑪莉蓮曼森的前妻─情色電影全世色情影片界頭牌脫衣舞孃黛塔范提思,這是她今年在英情色國唯一一場表演。

以一九四零年代風格演出的黛塔范提思表演性感的天堂鳥、旋轉木馬及羽扇等舞蹈AV女優

參展攤位有的推廣情趣用品,有的公開展示人體藝術和人體雕塑,也有情色藝術家工會成員提供建議。

Anonymous said...

童裝批發
童裝批發
童裝
童裝
酒店喝酒
酒店消費
暑假打工
寒假打工
酒店經紀人
酒店現領
禮服店
酒店小姐
酒店兼職
酒店上班
酒店兼職
禮服店
酒店上班
酒店打工
酒店小姐
酒店經紀
酒店兼差
假日打工
台北酒店經紀
寒暑假打工
專業酒店經紀
酒店藝名
台北酒店
酒店日保
酒店入行
台北禮服店
酒店類型
酒店午場
酒店規定
酒店行政
酒店資訊