[seasar-dotnet:1716] [dbflute Procedure Generation Error]

[thomas]

Hello Kubo さん,

I tested under java environment with dbflute-0.9.7.1-06-SNAPSHOT.
I got the following Exception.

Look! Read the message below.
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
*Failed to get a list of procedures.*

[Unified Schema]
{pmsdbphase2.dbo as main}

[Current Procedure]
*PMS_FM_ProposalQty_UF;0*

[Unexpected Exception]
java.lang.NumberFormatException
null
* * * * * * * * * */


In my database i have lots of procedures and one function(*
PMS_FM_ProposalQty_UF).*This is my function.

*PMS_FM_ProposalQty_UF

Create FUNCTION [dbo].[PMS_FM_ProposalQty_UF]
(
   @slno    INT
  [E-MAIL ADDRESS DELETED]   VARCHAR(34)
  [E-MAIL ADDRESS DELETED]   DATE
  [E-MAIL ADDRESS DELETED]   NUMERIC(6,0)
  [E-MAIL ADDRESS DELETED]  VARCHAR(34)
  [E-MAIL ADDRESS DELETED]  DATE
  [E-MAIL ADDRESS DELETED]   NUMERIC(6,0)

)
--returns numeric(6,0)
RETURNS @Calculation_Requirement TABLE
(
  PrevPartNo   VARCHAR(34)
 ,PrevReqDate  DATE
 ,PrevSoh   NUMERIC(6,0)
 ,proposal   NUMERIC(6,0)
 ,SOH    NUMERIC(6,0)

)
AS
BEGIN
...
...
...
return


* How to exclude this function while running sql2entity,so that i can get
list of my procedures.

Thanks,
Thomas.*



*
-------------- next part --------------
HTML$B$NE:IU%U%!%$%k$rJ]4I$7$^$7$?(B...
URL: <http://ml.seasar.org/archives/seasar-dotnet/attachments/20100610/baa532b6/attachment.html>