なんとか引数のサイズを指定できないものかと思い、
資料を読んでいると「サブタイプ」なるものを発見!!
これはイケルと思い試してみました。

テスト用パッケージ仕様部のソース

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 karua
引数がサイズを持っているって、それより大きな物を渡された場合どういう副作用を期待しているかってことですね。
エラー?切り落とす?どっちにせよ、副作用に期待せずにチェックや処理をしたほうがいい気もします。

# re: [PL/SQL]プロシージャ引数に引数のサイズを指定できない2

2007/07/24 9:34 by 十郎
>黒龍様
ありがとうございます。
エントリの仕方がまずかったです。
すみません。
実際の開発で別に困ってないんです^^
ご指摘の通り、
呼び出し側(あるいはプロシージャ側)でチェックするだけの話なので。

できれば便利だよねぇって話をしてて、
気になったもので・・・

>karua様
ありがとうございます。
ご指摘の通りです。
使う前にチェックしとくのが礼儀だと思います^^




サブタイプについては、使う上で覚えていないと
間違って使っちゃいそうな所があったので、
後日まとめてUPしようと思います。

# DzuDCIfZDwUJ

2014/08/06 22:58 by http://crorkz.com/
KTQeEu Thanks a lot for the article post.Much thanks again. Great.

# tYOefMEbGF

2014/08/29 20:22 by http://criminallawyersottawa.com
Super-Duper site! I am loving it!! Will come back again. I am taking your feeds also.

# wtoBWqZODq

2014/09/10 19:30 by http://www.nobisca.com
Would you be interested by exchanging links?

# YcnDepZYtZZrFV

2014/09/17 16:57 by http://www.1818-888.com
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 http://catholicanswer.info/story/94897
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
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
Great article. I'm facing some of these issues as well..

# XrElNdNOIFEzfcvVh

2018/12/20 8:55 by https://www.suba.me/
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
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
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
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
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
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
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 f
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 https://amzn.to/365xyVY
in the United States Fish and Wildlife Service.

# Illikebuisse mbmsf

2021/07/05 4:31 by pharmacepticacom
cheap sildenafil online https://pharmaceptica.com/

# best erectile drug

2021/07/09 19:17 by is hydroxychloroquine safe
malaria drug hydroxychloroquine https://plaquenilx.com/# can hydroxychloroquine

# doxycycline 500mg https://doxycyline1st.com/
order doxycycline online

2022/02/26 9:50 by Jusidkid
doxycycline 500mg https://doxycyline1st.com/
order doxycycline online

# clomid 2020 http://clomidfast.site/

2022/04/12 13:05 by Clomids
clomid 2020 http://clomidfast.site/

# prednisone in uk http://prednisoneen.store/

2022/04/16 23:00 by Prednisone
prednisone in uk http://prednisoneen.store/

# tgbwsrhvtzof

2022/05/07 4:05 by lyxzmd
hydrocholorquine https://keys-chloroquinehydro.com/

# tduzwezemdkg

2022/05/14 0:18 by qaofgd
hsq medical abbreviation https://keys-chloroquineclinique.com/

# lasix uses https://buylasix.icu/
lasix for sale

2022/06/24 17:17 by LasixRx
lasix uses https://buylasix.icu/
lasix for sale

# purchase clomid online https://clomidonline.icu/

2022/07/08 13:45 by Clomidj
purchase clomid online https://clomidonline.icu/

# ivermectin for sheep and goats https://stromectolbestprice.com/

2022/07/30 0:40 by BestPrice
ivermectin for sheep and goats https://stromectolbestprice.com/

# prednisone tablets canada https://deltasone.icu/
prednisone 50 mg tablet canada

2022/08/22 9:51 by Prednisone
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 EdPills
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
doxycycline 100mg capsules https://buydoxycycline.icu/

#  https://clomidforsale.site/

2022/11/13 14:29 by ForSale
https://clomidforsale.site/

# 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 h
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 Prednisone
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
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 candipharm.com
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 EdPills
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 CanadaBest
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 Doxycycline
doxycycline tablets - https://doxycyclinesale.pro/#

# prednisone cost 10mg - https://prednisonesale.pro/#

2023/04/22 4:58 by Prednisone
prednisone cost 10mg - https://prednisonesale.pro/#

# best non prescription ed pills: https://edpills.pro/#

2023/05/15 15:44 by EdPillsPro
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
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
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
paxlovid cost without insurance https://paxlovid.store/
paxlovid buy

# find singles dating

2023/08/09 13:32 by WayneGurry
victoriasonlinedating: https://datingtopreview.com/# - free dating and chatting

# comprare farmaci online con ricetta

2023/09/25 11:18 by Archieonelf
https://farmaciabarata.pro/# п»?farmacia online

# farmacie on line spedizione gratuita

2023/09/26 12:20 by Archieonelf
https://onlineapotheke.tech/# versandapotheke

# online apotheke preisvergleich

2023/09/26 13:38 by Williamreomo
http://onlineapotheke.tech/# online apotheke preisvergleich
versandapotheke deutschland

# online apotheke gГјnstig

2023/09/27 0:49 by Williamreomo
http://onlineapotheke.tech/# versandapotheke deutschland
online apotheke preisvergleich

# online apotheke deutschland

2023/09/27 2:49 by Williamreomo
https://onlineapotheke.tech/# internet apotheke
versandapotheke

# п»їonline apotheke

2023/09/27 9:37 by Williamreomo
http://onlineapotheke.tech/# п»?online apotheke
gГ?nstige online apotheke

# gГјnstige online apotheke

2023/09/27 11:11 by Williamreomo
http://onlineapotheke.tech/# online apotheke versandkostenfrei
п»?online apotheke

# comprare farmaci online all'estero

2023/09/27 12:16 by Archieonelf
https://farmaciaonline.men/# farmacie online autorizzate elenco

# acquistare farmaci senza ricetta

2023/09/27 19:10 by Rickeyrof
acheter sildenafil 100mg sans ordonnance

# farmaci senza ricetta elenco

2023/09/27 22:42 by Rickeyrof
acheter sildenafil 100mg sans ordonnance

# doxycycline 1mg

2023/10/08 9:26 by GaylordPah
They offer unparalleled advice on international healthcare. http://edpillsotc.store/# herbal ed treatment

# where to get doxycycline

2023/10/09 11:23 by GaylordPah
Always professional, whether dealing domestically or internationally. http://edpillsotc.store/# ed medications online

# mexican rx online

2023/10/16 12:57 by Dannyhealm
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 Dannyhealm
Offering a global touch with every service. http://mexicanpharmonline.com/# mexican pharmaceuticals online

# buying pharmaceuticals from canada

2023/10/16 15:42 by Dannyhealm
Consistently excellent, year after year. http://mexicanpharmonline.com/# reputable mexican pharmacies online

# canadian pills online

2023/10/16 21:04 by Dannyhealm
Quick turnaround on all my prescriptions. http://mexicanpharmonline.shop/# reputable mexican pharmacies online

# best rated canadian pharmacies

2023/10/17 7:20 by Dannyhealm
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 Dannyhealm
A gem in our community. https://mexicanpharmonline.shop/# mexican pharmaceuticals online

# prescription meds from canada

2023/10/17 9:35 by Dannyhealm
Their senior citizen discounts are much appreciated. http://mexicanpharmonline.com/# mexico drug stores pharmacies

# online mexican pharmacies

2023/10/17 10:43 by Dannyhealm
Their staff is so knowledgeable and friendly. https://mexicanpharmonline.shop/# mexico drug stores pharmacies

# pharm store canada

2023/10/17 16:59 by Dannyhealm
Consistency, quality, and care on an international level. https://mexicanpharmonline.shop/# mexican pharmaceuticals online

# pharmacies in canada online

2023/10/18 5:25 by Dannyhealm
They always prioritize the customer's needs. https://mexicanpharmonline.com/# reputable mexican pharmacies online

# order prescription from canada

2023/10/18 7:10 by Dannyhealm
Love their range of over-the-counter products. http://mexicanpharmonline.com/# mexican rx online

# candaian pharmacies

2023/10/18 22:54 by Dannyhealm
Their online chat support is super helpful. http://mexicanpharmonline.com/# reputable mexican pharmacies online

# rx mexico online

2023/10/19 10:52 by Dannyhealm
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 Plavixxx
Cost of Plavix without insurance https://plavix.guru/ Plavix 75 mg price

# paxlovid india

2023/10/26 5:40 by LarryNef
http://plavix.guru/# generic plavix

# mexican border pharmacies shipping to usa

2023/11/17 1:18 by DavidFap
https://edpills.icu/# buying ed pills online

# doxycycline 100mg price https://doxycycline.forum/ buy generic doxycycline

2023/11/25 13:36 by Doxycycline
doxycycline 100mg price https://doxycycline.forum/ buy generic doxycycline

# paxlovid price

2023/12/01 5:24 by Mathewhip
paxlovid covid http://paxlovid.club/# paxlovid for sale

# list of aarp approved pharmacies

2023/12/02 1:02 by MichaelBum
https://claritin.icu/# ventolin nz

# cheap prescriptions

2023/12/02 15:25 by MichaelBum
https://clomid.club/# cheap clomid prices

# comprare farmaci online con ricetta https://farmaciait.pro/ comprare farmaci online all'estero

2023/12/04 10:27 by Farmacia
comprare farmaci online con ricetta https://farmaciait.pro/ comprare farmaci online all'estero

# farmacias online baratas

2023/12/07 14:33 by RonnieCag
http://tadalafilo.pro/# farmacias baratas online envío gratis

# farmacia online madrid

2023/12/07 17:34 by RonnieCag
https://tadalafilo.pro/# farmacias baratas online envío gratis

# ï»¿farmacia online

2023/12/07 23:57 by RonnieCag
https://farmacia.best/# farmacia 24h

# farmacia envíos internacionales

2023/12/08 3:08 by RonnieCag
http://vardenafilo.icu/# farmacia online envío gratis

# farmacia envíos internacionales

2023/12/08 20:43 by RonnieCag
https://tadalafilo.pro/# farmacia online madrid

# farmacia envíos internacionales

2023/12/09 15:09 by RonnieCag
http://farmacia.best/# farmacia online barata

# farmacias online seguras

2023/12/09 18:20 by RonnieCag
http://vardenafilo.icu/# farmacia online barata

# farmacias baratas online envío gratis

2023/12/09 21:43 by RonnieCag
https://farmacia.best/# farmacia online

# farmacia barata

2023/12/10 14:18 by RonnieCag
https://tadalafilo.pro/# farmacias online seguras

# farmacia online 24 horas

2023/12/10 21:48 by RonnieCag
http://sildenafilo.store/# sildenafil 100mg genérico

# farmacias online seguras en españa

2023/12/11 8:04 by RonnieCag
https://tadalafilo.pro/# farmacia online 24 horas

# ï»¿farmacia online

2023/12/11 13:30 by RonnieCag
https://tadalafilo.pro/# farmacias online seguras

# ï»¿farmacia online

2023/12/11 16:29 by RonnieCag
https://tadalafilo.pro/# farmacias online seguras

# farmacias baratas online envío gratis

2023/12/12 9:32 by RonnieCag
https://tadalafilo.pro/# farmacia online madrid

# farmacias online seguras en españa

2023/12/13 11:50 by RonnieCag
http://farmacia.best/# farmacia 24h

# Pharmacie en ligne fiable

2023/12/13 14:40 by Larryedump
https://pharmacieenligne.guru/# Pharmacie en ligne sans ordonnance

# pharmacie ouverte

2023/12/14 23:19 by Larryedump
https://pharmacieenligne.guru/# Pharmacie en ligne livraison rapide

# Pharmacie en ligne France

2023/12/15 9:44 by Larryedump
http://pharmacieenligne.guru/# Pharmacie en ligne livraison 24h

# buy paxlovid online

2023/12/26 23:46 by Brianmooda
https://paxlovid.win/# buy paxlovid online

# cytotec buy online usa https://cytotec.club/ buy cytotec pills

2024/04/28 2:05 by Cytotec
cytotec buy online usa https://cytotec.club/ buy cytotec pills
コメントの入力
タイトル
名前
Url
コメント