or Create a profile

Home → Help and guidance →

Procedure inside of an Oracle Package

martindalec's Avatar

martindalec

27 Oct, 2010 03:22 PM via web

Hello,

I'm looking for information on how to call an insert procedure that is inside of an Oracle Package. Will the SqlInsert("") method accomplish this for me or do I need to revert to standard HBM mappings?

Thanks

  1. Support Staff 2 Posted by James Gregory on 27 Oct, 2010 03:29 PM

    James Gregory's Avatar

    I have no idea. How would you normally call a procedure inside an oracle package?

  2. 3 Posted by martindalec on 27 Oct, 2010 05:14 PM

    martindalec's Avatar

    If I had a package called Common_Log_Pkg and inside of there a procedure called Log, I would call it like Common_Log_Pkg.Log(params). Our DBAs here are fond of creating giant packages with a ton of different procedures inside of them.

  3. Support Staff 4 Posted by James Gregory on 05 Nov, 2010 02:03 PM

    James Gregory's Avatar

    Our stored procedure support is patchy at best, so what you're wanting to do might not be entirely possible.

    You should have a read of Ayende's blog post on the NHibernate stored procedure support and take it from there. If you have any specific questions on how to convert between the XML examples and Fluent, give us a shout.

Reply to this discussion

Preview Comments are parsed with Markdown. Help with syntax

Attached Files

    You can attach files up to 10MB

    What is two plus two?

    2 people watching.

    • New Issue

    • Conversation Started

      The Fluent NHibernate staff has started a conversation to resolve this discussion.

    • Close the discussion

    Recent Discussions

    09 Dec, 2010 09:42 AM Property formula is not working.
    08 Dec, 2010 05:24 PM Setting length on composite -key property
    02 Dec, 2010 09:33 PM Setting Component as Unique Key
    02 Dec, 2010 07:29 PM Conventions for ICompositeUserTypes and field overrides
    26 Nov, 2010 01:24 PM Maping details collection using interface for detail

     

    22 Nov, 2010 09:59 PM Mapping a view without a unique id column
    22 Nov, 2010 09:27 PM <many-to-one> and access setting
    18 Nov, 2010 03:32 PM Control the name of the Primary Key and Unique Constraint Names
    18 Nov, 2010 03:00 PM ForeignKeyConstraintName for References
    14 Nov, 2010 12:40 PM SQLite Versioning Configuration Question