<tt>yoshi$B$G$9!#(B</tt> <tt>$B5WJ](B</tt>$B$5$s!"$$$D$b$"$j$,$H$&$4$6$$$^$9!#(B $B65$($F$$$?$@$$$?J}K!$G$&$^$/$$$-$^$7$?!#!!(B <table width=100%> <tr valign=top> <td width=40%>kubo <dbflute@gmail.com> $BAw?.<T(B: seasar-user-bounces@ml.seasar.org <div align=center> </div> 2013/11/18 23:15 <table border> <tr valign=top> <td bgcolor=white> <div align=center>seasar-user@ml.seasar.org $B$X(B $BJV?.$7$F$/$@$5$$(B</div></table> <td width=59%> <table width=100%> <tr> <td> <div align=right>$B08@h(B</div> <td valign=top>seasar-user@ml.seasar.org <tr> <td> <div align=right>cc</div> <td valign=top> <tr> <td> <div align=right>$B7oL>(B</div> <td valign=top>[Seasar-user:21756] Re:        $B!Z(BDBFlute$B![%9%H%"%I!&%U%!%s%/%7%g%s$N(BCreate$BJ8$O$I$3$KCV$/$N$G$7$g$&$+(B</table> <table> <tr valign=top> <td> <td></table> </table> <tt>$B5WJ](B(jflute)$B$G$9(B $B$3$s$P$s$o!"(Byoshi$B$5$s(B DBFlute$B$4MxMQ$"$j$,$H$&$4$6$$$^$9!*(B $B%9%H%"%I%W%m%7!<%8%c$N:n@.$K4X$7$F$O!"(B $B8GDj$N$b$N$G$"$l$P(B playsql $B$G4IM}$9$k$N$,?d>)$G$9!#(B $B$D$^$j$3$A$i$G$9$M!#(B > $B#1!%(Bplaysql$B$N2<$KG[CV$7$F(Breplace-schema$B%?%9%/$G:n@.$5$l$k$h$&$K$9$k!#(B $B$?$@!"(BSQL$B%U%!%$%kFb$N(BSQL$B$N%G%j%_%?$,%G%U%)%k%H$G%;%_%3%m%s$J$N$G!"(B $B$=$N$^$^E=IU$1$F$b%;%_%3%m%s$GJ,3d$5$l$F$7$^$$$^$9!#(B $B$=$3$G!"!V$3$3$+$i$3$3$^$G$,0l$D$N(BSQL$B!W$H$$$&$h$&$J;XDj$,$G$-$^$9!#(B -- #df:begin# create or replace procedure SP_NO_PARAMETER as begin  dbms_output.put_line('aaa'); end SP_NO_PARAMETER; / -- #df:end# // SQL$B$NHO0O$NL@<(E*;XDj(B http://dbflute.seasar.org/ja/manual/function/generator/task/replaceschema/createtable.html#beginend $B$<$R!"$3$A$i$r;n$7$F$_$F$/$@$5$$!#(B 2013/11/18  <yo-kitano@sknet.senko.co.jp>: > > $B$3$s$P$s$o!"(Byoshi$B$G$9!#(B > > DBFlute1.0.5A / Oracle(10g)$B$r;HMQ$7$F$$$^$9!#(B > > $B!!%9%H%"%I!&%U%!%s%/%7%g%s$r;HMQ$7$F$$$k$N$G$9$,(B > > $B!!%9%H%"%I!&%U%!%s%/%7%g%s$N(BCreate$BJ8$O$I$3$KCV$/$N$,@5$7$$$d$jJ}$G$7$g$&$+!)(B > > $B#1!%(Bplaysql$B$N2<$KG[CV$7$F(Breplace-schema$B%?%9%/$G:n@.$5$l$k$h$&$K$9$k!#(B > > $B#2!%30=P$7(BSQL$B$HF1$8=j$KG[CV$7$F(Bsql2entity$B%?%9%/$G:n@.$5$l$k$h$&$K$9$k!#(B > > > $B#1$N$d$jJ}$G9T$&$H$J$<$+0J2<$N%(%i!<$,H/@8$7:n@.$5$l$^$;$s!#(B > > [SQLException] > java.sql.SQLException > ORA-06550: $B9T(B3$B!"Ns(B10: > PLS-00103: $B5-9f(B"end-of-file"$B$,8+$D$+$j$^$7$?!#(B $B<!$N$&$A$N(B1$B$D$,F~$k$H$-(B: > >    . ( * @ % & = - + ; < / > at in is mod remainder not rem >    <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ >    LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ > > $B$=$NB>$N%*%i%/%k$N%/%i%$%"%s%H$G:n@.$9$k$HLdBj$J$/:n@.$G$-$^$9!#(B > > $B#2$N$d$jJ}$G9T$&$H!"$=$N%9%H%"%I%U%!%s%/%7%g%s$r;H$&(BSQL$B$,@h$K<B9T$5$l(B > $B%(%i!<$K$J$C$F$7$^$$$^$9!#(B > > $B:n@.$7$h$&$H$7$F$$$k%9%H%"%I%U%!%s%/%7%g%s$O0J2<$NMM$J$b$N$G$9!#(B > > CREATE OR REPLACE FUNCTION getNmArrivshipKb(kbArrivship in > MA_CODE.CD_DETAIL%TYPE) return nvarchar2 is >   ret MA_CODE.NM_DETAIL%TYPE; > begin >   select NM_DETAIL into ret >   from MA_CODE >   where KB_SYSTEM = 'CMN' >   and CD_DIVIDE = 'KB_ARRIVSHIP' >   and CD_DETAIL = kbArrivship; >   return ret; > exception > when others then >   return null; > end; > > $B$4B8CN$N$+$?$,$*$i$l$^$7$?$i$h$m$7$/$*4j$$$7$^$9!#(B > > $B0J>e!"$h$m$7$/$*4j$$$$$?$7$^$9!#(B > _______________________________________________ > Seasar-user mailing list > Seasar-user@ml.seasar.org > https://ml.seasar.org/mailman/listinfo/seasar-user > _______________________________________________ Seasar-user mailing list Seasar-user@ml.seasar.org https://ml.seasar.org/mailman/listinfo/seasar-user </tt>