CodeSmith Community
Your Code. Your Way. Faster!

Oracle Shema Provider can not retrieve primary keys of the database tables...

Latest post 09-08-2006 9:08 AM by onderorgun. 0 replies.
  • 09-08-2006 9:08 AM

    Oracle Shema Provider can not retrieve primary keys of the database tables...

      Hi, 

      I just started to use codesmith with Oracle database ( version > 9 )
      I configured oracle-native-shema-provider and tested my connection. It is ok.
      But when I try to create stored procedures witt AllStoredProcedures.cst (shipped with the product), I receive the following error:

    Column 'constraint_name' does not belong to table Table.

    An error of type "ArgumentException" occured while attempting to execute this template.  To enable Just-In-Time debugging on this template set the "Debug" attribute to "True" in the "CodeTemplate" directive and add a "Debugger.Break()" statement in the template.


    System.ArgumentException: Column 'constraint_name' does not belong to table Table.
       at System.Data.DataRow.GetDataColumn(String columnName)
       at System.Data.DataRow.get_Item(String columnName)
       at SchemaExplorer.OracleNativeSchemaProvider.GetTablePrimaryKey(String connectionString, TableSchema table)
       at SchemaExplorer.TableSchema.get_HasPrimaryKey()
       at _CodeSmith.AllStoredProcedures_cst.__RenderMethod1(TextWriter writer, Control control)
       at CodeSmith.Engine.DelegateControl.Render(TextWriter writer)
       at CodeSmith.Engine.Control.RenderChildren(TextWriter writer)
       at CodeSmith.Engine.CodeTemplate.Render(TextWriter writer)
       at CodeSmith.Engine.CodeTemplate.RenderToString()
       at ej.s()

     I have tried other templates but none of the worked and I always received the same error.

     Do I make something wrong?

     Thanks...
    M. Onder Orgun

    • Post Points: 5
Page 1 of 1 (1 items) | RSS
Copyright © 2008 CodeSmith Tools, LLC
Powered by Community Server (Commercial Edition), by Telligent Systems