The "Unofficial" Oracle Schema Provider For CodeSmith

You are going to need to re-compile the Oracle schema provider assembly referencing the 2.6 CodeSmith assemblies instead of the 2.5 assemblies.

Hope this helps,
Eric J. Smith

I just posted a version compiled for 2.6 on the top of this thread.

Thanks,
Eric J. Smith

Is this dependent on an Oracle Client being installed separate to the dot Net Framework 1.1. I am getting the following error

System.DllNotFoundException: Unable to load DLL (oci.dll).
at System.Data.OracleClient.DBObjectPool.GetObject(Object owningObject, Boolean& isInTransaction)

I assumed that System.Data.OracleClient was independent of Oracle Client software, not a wrapper for it.

I am not familiar with connecting to Oracle so the connection string may be completely wrong - I am trying to connect to an IP address and port number in a Data Source portion of the connection string.

Regards.
JTE

The answer to my own question is "Yes - you have to install the Oracle (9.2) client and configure it correctly to get the MS System.Data.OracleClient working - I could find no mention of this in the help files of visual studio but it is there in an obscure readme of one of the example downloads from MSDN

Post Edited (Jim Evans) : 10/28/2004 10:17:18 PM GMT

Hi All,
I'm attempting to use CodeSmith 2.6 with the Oracle Schema Provider to connect to and Oracle 7.3 instance without much success. Currently I'm receiving the following error when CodeSmith attempts to determine the tables in the database and was wondering if anyone had encountered this or a workaround:

System.Data.OracleClient.OracleException: ORA-01002: fetch out of sequence

at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
at System.Data.OracleClient.OracleDataReader.ReadInternal()
at System.Data.OracleClient.OracleDataReader.Read()
at SchemaExplorer.OracleNativeSchemaProvider.GetTables(String connectionString, DatabaseSchema database)
at SchemaExplorer.DatabaseSchema.get_Tables()
at SchemaExplorer.Design.TableSchemaPickerUI.b()

Regards,

Kirk.

The Oracle Managed Provider, which the Oracle Schema Provider uses... does not support Oracle 7.x.

Hello All! Very new to CodeSmith. I am trying to use the canned DBDocumenter that comes with it and am getting an error. I followed the top link and extracted the proper files for Oralce in my CodeSmith dir and created the extended properties table.

Here is the error:

System.NullReferenceException: Object reference not set to an instance of an object.
at _CodeSmithTemplate.table_details_cst.PrintColumnDocumentation(ColumnSchema column)
at _CodeSmithTemplate.table_details_cst.PrintTableDocumentation(TableSchema table)
at _CodeSmithTemplate.table_details_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.RenderToFile(String path, Boolean overwrite)
at _CodeSmithTemplate.tables_cst.GenerateTableDetailsHTML(DatabaseSchema database)
at _CodeSmithTemplate.tables_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.RenderToFile(String path, Boolean overwrite)
at _CodeSmithTemplate.master_cst.Go()
at _CodeSmithTemplate.master_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 H.Run()

Any thoughts?

MikeA.

I remember once some time ago trying to use the documentation templates against an Oracle database, but I found that the templates were written only with SQL Server in mind, and make use of SQL Server-specific extended properties.  That may be the problem...

As I am going thru the samples here I see that retrieval of command text (actual sproc code) is not yet written for the Oracle Schema provider. Any idea when / if this may happen?

Thanx.

Mike A.

I never added it because I never had a need for it.  Also, I'm not actively using Oracle these days, so I'm not in a position to add it myself.  If you want to add it, I'd say go for it.  One of the main issues is that as I recall, there is no way to get just the source for just one procedure in a package... you would be getting the entire contents of the package, and be left to sort out what constitutes the beginning and end of each procedure yourself.  I never had a reason to implement that part...

Mike,

If you are just wanting to generate documentation then to me... the procedure text really isn't that important. Do you really want this to be part of your documentation?

Eric J. Smith

Hey Eric, You are right, but I want to allow my developers to add comments in a certain format so I can then add special documentation. I don't just want to read the stored proc source and then echo back to my doc files.

Mike.

Ahhh... that makes sense. Sounds like a cool feature. If you implement that in the Oracle provider, please do share your work in the forums here.

Eric J. Smith

does anyone know how to get this oracle schema provider to work in code smith 3.0??

nzdirtyanimal wrote:

does anyone know how to get this oracle schema provider to work in code smith 3.0??

I've got same problem with 3.2, can anyone please suggest where to go next ??

I've downloaded the zip, Oracle+Native+Schema+Provider-combined.zip, and extracted the files in the OracleSchemaProvider30Binaries.zip

Put those in my directory, C:\Program Files\CodeSmith\v3.2\SchemaProviders

But I still only get the ADOXSchemaProvider and SqlSchemaProvider in my list of Provider Types in the Data Source dialog

In VS2005, I can create a new database connection to my Oracle d/b fine, and browse through the schema, see data, etc.

This is in both CodeSmith Studio and VS2005 with CodeSmith 3.2 installed

Hi Steve,

My first guess is that you will need to recompile the provider using VS2005.  Typically, providers written for previous versions of CodeSmith have to be recompiled to work in later versions.

Best Regards,
David