Error with Oracle Custom Stored Proceduers

[GoogleCodeExporter]

1-I have a Custom Stored Procedures in my oracle database 
2-I choose to include my Procedures in the output Projects 
3-I run the template it give me this error
4-This exception is generated

System.ArgumentException: String cannot be of zero length.
Parameter name: oldValue
   at System.String.Replace(String oldValue, String newValue)
   at 
MoM.Templates.CommonSqlCode.TransformStoredProcedureInputsToMethodComments
(ParameterSchemaCollection inputParameters) in c:\Documents and 
Settings\Administrator\Desktop\nettiers-2.3.0.b2
\TemplateLib\CommonSqlCode.cs:line 3237
   at 
_CodeSmith.NetTiers_cst.EntityProviderBaseCoreGenerated.__RenderMethod1
(TextWriter writer, Control control) in c:\Documents and 
Settings\Administrator\Desktop\nettiers-2.3.0.b2
\DataAccessLayer\Bases\EntityProviderBaseCore.generated.cst:line 552
   at CodeSmith.Engine.DelegateControl.Render(TextWriter writer)
   at CodeSmith.Engine.Control.RenderChildren(TextWriter writer)
   at CodeSmith.Engine.Control.Render(TextWriter writer)
   at CodeSmith.Engine.CodeTemplate.Render(TextWriter writer)
   at CodeSmith.Engine.CodeTemplate.RenderToFile(OutputFile outputFile, 
Boolean overwrite)
   at CodeSmith.Engine.CodeTemplate.RenderToFile(String path, Boolean 
overwrite)
   at _CodeSmith.NetTiers_cst.RenderToFile(String templateName, String 
path, Boolean overwrite) in c:\Documents and 
Settings\Administrator\Desktop\nettiers-2.3.0.b2\NetTiers.cst:line 709
   at _CodeSmith.NetTiers_cst.Go() in c:\Documents and 
Settings\Administrator\Desktop\nettiers-2.3.0.b2\NetTiers.cst:line 3884
   at _CodeSmith.NetTiers_cst.__RenderMethod1(TextWriter writer, Control 
control) in c:\Documents and Settings\Administrator\Desktop\nettiers-
2.3.0.b2\NetTiers.cst:line 4781
   at CodeSmith.Engine.DelegateControl.Render(TextWriter writer)
   at CodeSmith.Engine.Control.RenderChildren(TextWriter writer)
   at CodeSmith.Engine.Control.Render(TextWriter writer)
   at CodeSmith.Engine.CodeTemplate.Render(TextWriter writer)
   at CodeSmith.Engine.CodeTemplate.RenderToString()
   at CodeSmith.Gui.CodeTemplateGenerator.f(Object A_0, EventArgs A_1)

Original issue reported on code.google.com by mohammed...@gmail.com on 28 Dec 2008 at 3:18

[GoogleCodeExporter]

Hello,

Could you please include your schema as well as your csp file.

Thanks
-Blake Niemyjski

Original comment by bniemyjski on 3 Feb 2009 at 2:45

• Changed state: Accepted

[GoogleCodeExporter]

Hello,

Can you reproduce this issue with CodeSmith 5.1.1 and .netTiers 2.3 RTM?

Thanks
-Blake Niemyjski

Original comment by bniemyjski on 25 May 2009 at 3:30

• Changed state: AwaitingInfo
• Added labels: Platform-Oracle

[GoogleCodeExporter]

Just started looking at Oracle custom procedures, and found this same problem 
(after
enabling AllowGetCommandResultSchemas).
Quick debug showed me that the problem was as simple as a String.Replace() call:
 GetFieldName(outputParameters[i]).Replace(ParameterPrefix, "")
When ParameterPrefix is blank that falls over, in both
TransformStoredProcedureInputsToMethodComments
 and TransformStoredProcedureOutputsToMethodComments.

Now starting to look at the rest of the code, so won't submit anything yet 
until I
investigate further.

Original comment by ben.le...@gmail.com on 18 Jan 2010 at 6:28

[GoogleCodeExporter]

Hello,

Thanks for the heads up :). Please keep us updated.

Thanks
-Blake Niemyjski

Original comment by bniemyjski on 18 Jan 2010 at 11:25

[GoogleCodeExporter]

I use Nettier 2.3 and CodeSmith 5.2.0. I meet the same exception when I tried 
to 
generate Oracle Custom Stored Procedures. Please help me :(

Error: Server.csp(0,0) String cannot be of zero length.
Parameter name: oldValue
Stack Trace:
   at System.String.Replace(String oldValue, String newValue)
   at 
MoM.Templates.CommonSqlCode.TransformStoredProcedureInputsToMethodComments(Param
eterS
chemaCollection inputParameters) in e:\Programs\nettiers\nettiers-
2.3.0\TemplateLib\CommonSqlCode.cs:line 3236
   at _CodeSmith.NetTiers_cst.ComponentDataAccess.__RenderMethod1(TextWriter writer, 
Control control) in e:\Programs\nettiers\nettiers-
2.3.0\Components\ComponentDataAccess.cst:line 1243
   at CodeSmith.Engine.DelegateControl.Render(TextWriter writer)
   at CodeSmith.Engine.Control.RenderChildren(TextWriter writer)
   at CodeSmith.Engine.Control.Render(TextWriter writer)
   at CodeSmith.Engine.CodeTemplate.Render(TextWriter writer)
   at CodeSmith.Engine.CodeTemplate.RenderToString()
   at _CodeSmith.NetTiers_cst.ComponentServiceBase.__RenderMethod1(TextWriter writer, 
Control control) in e:\Programs\nettiers\nettiers-
2.3.0\Components\ComponentServiceBase.cst:line 181
   at CodeSmith.Engine.DelegateControl.Render(TextWriter writer)
   at CodeSmith.Engine.Control.RenderChildren(TextWriter writer)
   at CodeSmith.Engine.Control.Render(TextWriter writer)
   at CodeSmith.Engine.CodeTemplate.Render(TextWriter writer)
   at CodeSmith.Engine.CodeTemplate.RenderToFile(OutputFile outputFile, Boolean 
overwrite)
   at CodeSmith.Engine.CodeTemplate.RenderToFile(String path, Boolean overwrite)
   at _CodeSmith.NetTiers_cst.RenderToFile(String templateName, String path, Boolean 
overwrite) in e:\Programs\nettiers\nettiers-2.3.0\NetTiers.cst:line 711
   at _CodeSmith.NetTiers_cst.Go() in e:\Programs\nettiers\nettiers-
2.3.0\NetTiers.cst:line 3863
   at _CodeSmith.NetTiers_cst.__RenderMethod1(TextWriter writer, Control control) in 
e:\Programs\nettiers\nettiers-2.3.0\NetTiers.cst:line 4799
   at CodeSmith.Engine.DelegateControl.Render(TextWriter writer)
   at CodeSmith.Engine.Control.RenderChildren(TextWriter writer)
   at CodeSmith.Engine.Control.Render(TextWriter writer)
   at CodeSmith.Engine.CodeTemplate.Render(TextWriter writer)
   at CodeSmith.Engine.CodeTemplate.RenderToFile(OutputFile outputFile, Boolean 
overwrite)
   at CodeSmith.Engine.CodeTemplate.RenderToFile(String path, Boolean overwrite)
   at CodeSmith.Engine.ProjectCodeGenerator.GenerateCode(CodeSmithProject csp)
Unable to render output NetTiers.txt, skipping...

Original comment by hithanht...@gmail.com on 5 Feb 2010 at 2:41