I generated all class for tables of database, but did't generate any procedures. My web config like
<section name="SubSonicService" type="SubSonic.SubSonicSection, SubSonic" requirePermission="false"/>
<add name="ConnectionString" connectionString="Data Source=hrm;User ID=hr;Password=hr;" providerName="System.Data.OracleClient"/>
<SubSonicService defaultProvider="Northwind">
<providers>
<clear/>
<add name="Northwind" type="SubSonic.OracleDataProvider, SubSonic" connectionStringName="ConnectionString" generatedNamespace="HRM"/>
</providers>
</SubSonicService>

What is my error? Help me generate Procedure or Package in Oracle

I find this error cause this code in OracleDataProvider.cs
const string SP_SQL = @"SELECT a.object_name, a.object_type, a.created, a.last_ddl_time
Bold ` FROM user_objects a
WHERE a.object_type IN ('PROCEDURE', 'FUNCTION', 'PACKAGE') ";

Delete comma before from statement.

 so this is a bug in the provider, right? Will you log it in codeplex?

I'm using sonic.exe to create class files from tables,stored procedure and packages.

But the only thing I see is that the table code is generated, no code is generated for the storedm procedures or packages from oracle?

The sonic.exe command line looks like :  generate /out APP_Code\Generated 

And my web.config looks like:

<configSections>
        <section name="SubSonicService" type="SubSonic.SubSonicSection, SubSonic" requirePermission="false"/>
    </configSections>
    <appSettings/>
    <SubSonicService defaultProvider="MyDB">
        <providers>
            <clear/>
            <add name="MyDB" type="SubSonic.OracleDataProvider, SubSonic" connectionStringName="MyConnectionString" generatedNamespace="MyDB"/>
        </providers>
    </SubSonicService>
    <connectionStrings>
        <add name="MyConnectionString" connectionString="Data Source=10.226.135.105/XE;Persist Security Info=True;User ID=x;Password=x;Unicode=True" providerName="System.Data.OracleClient"/>
    </connectionStrings>

What I am doing wrong ? Or are stored procedures and packages not supported by subsonic when using oracle?

 

 

You're not doing anything wrong. I just uploaded warriorvn's fix as a patch.

http://www.codeplex.com/subsonic/WorkItem/View.aspx?WorkItemId=9875

Thanks guys... Fixed in Revision 282. 

I am using Oracle 10G

I have all my tables generated, but none of my stored procedures. I went and got this patch and updated my code. This still does not generate any stored procedures.

Has anyone been successful generating stored procedures for Oracle, or is this just a 10G problem? Maybe a schema problem? 

 

 

I just used the SubSonic 2.1 Beta 1 release to see if this helped generate my SP's. It generated some of them, but it does not compile.

I guess subsonic isn't ready for Oracle stored procedures? But it does work great for all my tables.

The main dev work is done against MSSQL 2005. The other providers don't get as much coverage. Anything you can do to help (unit tests, provider code, etc) is appreciated!