なんとか引数のサイズを指定できないものかと思い、
資料を読んでいると「サブタイプ」なるものを発見!!
これはイケルと思い試してみました。
テスト用パッケージ仕様部のソース
create or replace PACKAGE "TEST" IS
SUBTYPE varchar2SubType IS VARCHAR2(8);
FUNCTION SUBTYPE_TEST
(
inParameter IN varchar2SubType
)
RETURN NUMBER;
PROCEDURE TM_SUBTYPE_TEST;
END "TEST";
テストパッケージ本体部のソース
create or replace PACKAGE BODY "TEST" IS
FUNCTION SUBTYPE_TEST
(
inParameter IN varchar2SubType
)
RETURN NUMBER
IS
BEGIN
DBMS_OUTPUT.PUT_LINE('SUBTYPE_TEST' || inParameter);
RETURN 0;
END;
PROCEDURE TM_SUBTYPE_TEST
IS
ret NUMBER(1);
BEGIN
ret := TEST.SUBTYPE_TEST('12345678901234567890');
END;
END "TEST";
んで、テストプロシージャ「TM_SUBTYPE_TEST」の実行結果(DBMS_OUTPUTの値)がこれ
SUBTYPE_TEST12345678901234567890
8桁以上受け付けてるじゃないですか・・・
絶望しましたorz
フィードバック
# re: [PL/SQL]プロシージャ引数に引数のサイズを指定できない2
2007/07/23 15:30 by
ん~いまいちわかって無いんですが呼び出し側のPartialでチェックとかはやっぱし面倒?
# re: [PL/SQL]プロシージャ引数に引数のサイズを指定できない2
2007/07/23 15:42 by
一応補足するとストアドの呼び出しであればパラメータチェックや戻り値の設定の為にpartialを書くだろうからという前提からです。
(デフォだと引数がint?になっちゃうからとか戻り値がパラメータからの詰め替えが必要などのアレです)
# re: [PL/SQL]プロシージャ引数に引数のサイズを指定できない2
2007/07/23 17:20 by
引数がサイズを持っているって、それより大きな物を渡された場合どういう副作用を期待しているかってことですね。
エラー?切り落とす?どっちにせよ、副作用に期待せずにチェックや処理をしたほうがいい気もします。
# re: [PL/SQL]プロシージャ引数に引数のサイズを指定できない2
2007/07/24 9:34 by
>黒龍様
ありがとうございます。
エントリの仕方がまずかったです。
すみません。
実際の開発で別に困ってないんです^^
ご指摘の通り、
呼び出し側(あるいはプロシージャ側)でチェックするだけの話なので。
できれば便利だよねぇって話をしてて、
気になったもので・・・
>karua様
ありがとうございます。
ご指摘の通りです。
使う前にチェックしとくのが礼儀だと思います^^
サブタイプについては、使う上で覚えていないと
間違って使っちゃいそうな所があったので、
後日まとめてUPしようと思います。
# DzuDCIfZDwUJ
2014/08/06 22:58 by
KTQeEu Thanks a lot for the article post.Much thanks again. Great.
# tYOefMEbGF
2014/08/29 20:22 by
Super-Duper site! I am loving it!! Will come back again. I am taking your feeds also.
# wtoBWqZODq
2014/09/10 19:30 by
Would you be interested by exchanging links?
# YcnDepZYtZZrFV
2014/09/17 16:57 by
you have a fantastic blog right here! would you wish to make some invite posts on my blog?
# rAiADqBVJOVUBoKEWZ
2014/09/18 17:05 by
KHWooL I appreciate you sharing this post. Keep writing.
# I like it when individuals get together and share thoughts. Great website, stick with it!
2018/10/06 4:29 by
I like it when individuals get together and share thoughts.
Great website, stick with it!
# Great article. I'm facing some of these issues as well..
2018/11/04 4:49 by
Great article. I'm facing some of these issues as well..
# XrElNdNOIFEzfcvVh
2018/12/20 8:55 by
d2o2P9 Wow, great blog post.Thanks Again. Really Great.
# What's up, I desire to subscribe for this website to take hottest updates, thus where can i do it please help out.
2019/04/05 12:19 by
What's up, I desire to subscribe for this website to take hottest updates, thus where can i do it please
help out.
# Heya i am for the first time here. I came across this board and I find It really useful & it helped me out a lot. I hope to give something back and aid others like you aided me.
2019/05/12 19:34 by
Heya i am for the first time here. I came across this board and I find
It really useful & it helped me out a lot. I hope to give something back
and aid others like you aided me.
# Hi to every , since I am actually keen of reading this blog's post to be updated regularly. It contains pleasant material.
2019/07/24 0:16 by
Hi to every , since I am actually keen of reading this blog's post to be updated regularly.
It contains pleasant material.
# Hi to every , since I am actually keen of reading this blog's post to be updated regularly. It contains pleasant material.
2019/07/24 0:17 by
Hi to every , since I am actually keen of reading this blog's post to be updated regularly.
It contains pleasant material.
# Hi to every , since I am actually keen of reading this blog's post to be updated regularly. It contains pleasant material.
2019/07/24 0:18 by
Hi to every , since I am actually keen of reading this blog's post to be updated regularly.
It contains pleasant material.
# Hi to every , since I am actually keen of reading this blog's post to be updated regularly. It contains pleasant material.
2019/07/24 0:19 by
Hi to every , since I am actually keen of reading this blog's post to be updated regularly.
It contains pleasant material.
# Unquestionably believe that which you said. Your favorite reason appeared to be on the web the simplest thing to be aware of. I say to you, I certainly get annoyed while people think about worries that they just do not know about. You managed to hit the
2019/08/02 9:18 by
Unquestionably believe that which you said. Your favorite reason appeared
to be on the web the simplest thing to be aware of.
I say to you, I certainly get annoyed while people think about worries that they just
do not know about. You managed to hit the nail upon the top as well as defined out the
whole thing without having side-effects ,
people can take a signal. Will probably be back to get more.
Thanks pof natalielise
# IfvPgRneHfB
2021/07/03 3:07 by
in the United States Fish and Wildlife Service.
# Illikebuisse mbmsf
2021/07/05 4:31 by
# best erectile drug
2021/07/09 19:17 by
malaria drug hydroxychloroquine
https://plaquenilx.com/# can hydroxychloroquine
# doxycycline 500mg https://doxycyline1st.com/
order doxycycline online
2022/02/26 9:50 by
doxycycline 500mg
https://doxycyline1st.com/
order doxycycline online
# clomid 2020 http://clomidfast.site/
2022/04/12 13:05 by
# prednisone in uk http://prednisoneen.store/
2022/04/16 23:00 by
# tgbwsrhvtzof
2022/05/07 4:05 by
# tduzwezemdkg
2022/05/14 0:18 by
# lasix uses https://buylasix.icu/
lasix for sale
2022/06/24 17:17 by
lasix uses
https://buylasix.icu/
lasix for sale
# purchase clomid online https://clomidonline.icu/
2022/07/08 13:45 by
# ivermectin for sheep and goats https://stromectolbestprice.com/
2022/07/30 0:40 by
# prednisone tablets canada https://deltasone.icu/
prednisone 50 mg tablet canada
2022/08/22 9:51 by
prednisone tablets canada
https://deltasone.icu/
prednisone 50 mg tablet canada
# cheapest ed pills online https://ed-pills.xyz/
best male ed pills
2022/09/16 19:46 by
cheapest ed pills online
https://ed-pills.xyz/
best male ed pills
# doxycycline 100mg capsules https://buydoxycycline.icu/
2022/10/08 11:59 by
doxycycline 100mg capsules
https://buydoxycycline.icu/
# https://clomidforsale.site/
2022/11/13 14:29 by
# I do not even understand how I finished up right here, but I assumed this post used to be good. I do not know who you might be however certainly you're going to a famous blogger in case you aren't already. Cheers!
2022/11/29 5:15 by
I do not even understand how I finished up right here, but I assumed
this post used to be good. I do not know who you might be however certainly you're going to a famous blogger in case you aren't already.
Cheers!
# no prescription online prednisone https://prednisonepills.site/
prednisone for sale
2022/11/30 1:00 by
no prescription online prednisone
https://prednisonepills.site/
prednisone for sale
# Fantastic website. Lots of useful information here. I'm sending it to some pals ans also sharing in delicious. And naturally, thanks on your sweat!
2022/12/01 2:43 by
Fantastic website. Lots of useful information here. I'm sending
it to some pals ans also sharing in delicious.
And naturally, thanks on your sweat!
# Test, just a test
2022/12/13 4:50 by
canadian pharmacies ed pills
https://www.candipharm.com/
# Drug information. Learn about the side effects, dosages, and interactions.
https://edonlinefast.com
Long-Term Effects. Get information now.
2023/02/16 22:26 by
Drug information. Learn about the side effects, dosages, and interactions.
https://edonlinefast.com
Long-Term Effects. Get information now.
# Comprehensive side effect and adverse reaction information. Read information now.
https://canadianfast.com/
Read here. All trends of medicament.
2023/02/19 8:02 by
Comprehensive side effect and adverse reaction information. Read information now.
https://canadianfast.com/
Read here. All trends of medicament.
# doxycycline tablets - https://doxycyclinesale.pro/#
2023/04/21 17:41 by
# prednisone cost 10mg - https://prednisonesale.pro/#
2023/04/22 4:58 by
# best non prescription ed pills: https://edpills.pro/#
2023/05/15 15:44 by
best non prescription ed pills:
https://edpills.pro/#
# prednisone no rx https://prednisonepills.pro/# - prednisone 2.5 mg daily
2023/06/04 21:37 by
prednisone no rx
https://prednisonepills.pro/# - prednisone 2.5 mg daily
# paxlovid cost without insurance https://paxlovid.pro/# - paxlovid cost without insurance
2023/07/02 17:38 by
paxlovid cost without insurance
https://paxlovid.pro/# - paxlovid cost without insurance
# paxlovid cost without insurance https://paxlovid.store/
paxlovid buy
2023/07/13 13:29 by
paxlovid cost without insurance
https://paxlovid.store/
paxlovid buy
# find singles dating
2023/08/09 13:32 by
victoriasonlinedating:
https://datingtopreview.com/# - free dating and chatting
# comprare farmaci online con ricetta
2023/09/25 11:18 by
# farmacie on line spedizione gratuita
2023/09/26 12:20 by
# online apotheke preisvergleich
2023/09/26 13:38 by
http://onlineapotheke.tech/# online apotheke preisvergleich
versandapotheke deutschland
# online apotheke gГјnstig
2023/09/27 0:49 by
http://onlineapotheke.tech/# versandapotheke deutschland
online apotheke preisvergleich
# online apotheke deutschland
2023/09/27 2:49 by
https://onlineapotheke.tech/# internet apotheke
versandapotheke
# п»їonline apotheke
2023/09/27 9:37 by
http://onlineapotheke.tech/# п»?online apotheke
gГ?nstige online apotheke
# gГјnstige online apotheke
2023/09/27 11:11 by
http://onlineapotheke.tech/# online apotheke versandkostenfrei
п»?online apotheke
# comprare farmaci online all'estero
2023/09/27 12:16 by
https://farmaciaonline.men/# farmacie online autorizzate elenco
# acquistare farmaci senza ricetta
2023/09/27 19:10 by
acheter sildenafil 100mg sans ordonnance
# farmaci senza ricetta elenco
2023/09/27 22:42 by
acheter sildenafil 100mg sans ordonnance
# doxycycline 1mg
2023/10/08 9:26 by
They offer unparalleled advice on international healthcare.
http://edpillsotc.store/# herbal ed treatment
# where to get doxycycline
2023/10/09 11:23 by
Always professional, whether dealing domestically or internationally.
http://edpillsotc.store/# ed medications online
# mexican rx online
2023/10/16 12:57 by
They provide peace of mind with their secure international deliveries.
https://mexicanpharmonline.com/# mexico drug stores pharmacies
# prescription canada
2023/10/16 13:34 by
Offering a global touch with every service.
http://mexicanpharmonline.com/# mexican pharmaceuticals online
# buying pharmaceuticals from canada
2023/10/16 15:42 by
Consistently excellent, year after year.
http://mexicanpharmonline.com/# reputable mexican pharmacies online
# canadian pills online
2023/10/16 21:04 by
Quick turnaround on all my prescriptions.
http://mexicanpharmonline.shop/# reputable mexican pharmacies online
# best rated canadian pharmacies
2023/10/17 7:20 by
They always have the newest products on the market.
https://mexicanpharmonline.com/# mexico drug stores pharmacies
# pharmacies without prescriptions
2023/10/17 8:28 by
A gem in our community.
https://mexicanpharmonline.shop/# mexican pharmaceuticals online
# prescription meds from canada
2023/10/17 9:35 by
Their senior citizen discounts are much appreciated.
http://mexicanpharmonline.com/# mexico drug stores pharmacies
# online mexican pharmacies
2023/10/17 10:43 by
Their staff is so knowledgeable and friendly.
https://mexicanpharmonline.shop/# mexico drug stores pharmacies
# pharm store canada
2023/10/17 16:59 by
Consistency, quality, and care on an international level.
https://mexicanpharmonline.shop/# mexican pharmaceuticals online
# pharmacies in canada online
2023/10/18 5:25 by
They always prioritize the customer's needs.
https://mexicanpharmonline.com/# reputable mexican pharmacies online
# order prescription from canada
2023/10/18 7:10 by
Love their range of over-the-counter products.
http://mexicanpharmonline.com/# mexican rx online
# candaian pharmacies
2023/10/18 22:54 by
Their online chat support is super helpful.
http://mexicanpharmonline.com/# reputable mexican pharmacies online
# rx mexico online
2023/10/19 10:52 by
Their worldwide outreach programs are commendable.
http://mexicanpharmonline.com/# reputable mexican pharmacies online
# Cost of Plavix without insurance https://plavix.guru/ Plavix 75 mg price
2023/10/24 1:04 by
Cost of Plavix without insurance
https://plavix.guru/ Plavix 75 mg price
# paxlovid india
2023/10/26 5:40 by
# mexican border pharmacies shipping to usa
2023/11/17 1:18 by
https://edpills.icu/# buying ed pills online
# doxycycline 100mg price https://doxycycline.forum/ buy generic doxycycline
2023/11/25 13:36 by
doxycycline 100mg price
https://doxycycline.forum/ buy generic doxycycline
# paxlovid price
2023/12/01 5:24 by
paxlovid covid
http://paxlovid.club/# paxlovid for sale
# list of aarp approved pharmacies
2023/12/02 1:02 by
# cheap prescriptions
2023/12/02 15:25 by
# comprare farmaci online con ricetta https://farmaciait.pro/ comprare farmaci online all'estero
2023/12/04 10:27 by
comprare farmaci online con ricetta
https://farmaciait.pro/ comprare farmaci online all'estero
# farmacias online baratas
2023/12/07 14:33 by
http://tadalafilo.pro/# farmacias baratas online envÃo gratis
# farmacia online madrid
2023/12/07 17:34 by
https://tadalafilo.pro/# farmacias baratas online envÃo gratis
# farmacia online
2023/12/07 23:57 by
# farmacia envÃos internacionales
2023/12/08 3:08 by
http://vardenafilo.icu/# farmacia online envÃo gratis
# farmacia envÃos internacionales
2023/12/08 20:43 by
# farmacia envÃos internacionales
2023/12/09 15:09 by
http://farmacia.best/# farmacia online barata
# farmacias online seguras
2023/12/09 18:20 by
# farmacias baratas online envÃo gratis
2023/12/09 21:43 by
# farmacia barata
2023/12/10 14:18 by
https://tadalafilo.pro/# farmacias online seguras
# farmacia online 24 horas
2023/12/10 21:48 by
http://sildenafilo.store/# sildenafil 100mg genérico
# farmacias online seguras en españa
2023/12/11 8:04 by
https://tadalafilo.pro/# farmacia online 24 horas
# farmacia online
2023/12/11 13:30 by
https://tadalafilo.pro/# farmacias online seguras
# farmacia online
2023/12/11 16:29 by
https://tadalafilo.pro/# farmacias online seguras
# farmacias baratas online envÃo gratis
2023/12/12 9:32 by
# farmacias online seguras en españa
2023/12/13 11:50 by
# Pharmacie en ligne fiable
2023/12/13 14:40 by
https://pharmacieenligne.guru/# Pharmacie en ligne sans ordonnance
# pharmacie ouverte
2023/12/14 23:19 by
https://pharmacieenligne.guru/# Pharmacie en ligne livraison rapide
# Pharmacie en ligne France
2023/12/15 9:44 by
http://pharmacieenligne.guru/# Pharmacie en ligne livraison 24h
# buy paxlovid online
2023/12/26 23:46 by
# cytotec buy online usa https://cytotec.club/ buy cytotec pills
2024/04/28 2:05 by
cytotec buy online usa
https://cytotec.club/ buy cytotec pills