Oracle store procedures

Trixz · Post by **Trixz** » Thu 30 Apr 2009 08:29

I downloaded the new Entity Developer and tried to add my storeprocedures to the model. But when i look under the storeprocedures the list is empty.

All procedures are stored in packages in the Oracle db, and belongs to the user. Why can't i see them and add them?

AndreyR · Post by **AndreyR** » Thu 30 Apr 2009 10:28

Sorry, this functionality is not available at the moment. We are implementing the Oracle packages support.

Trixz · Post by **Trixz** » Thu 30 Apr 2009 10:43

Is there any way I can add code for calling functions and storeprocedures in packages when the code been generated?

Trixz · Post by **Trixz** » Thu 30 Apr 2009 10:57

Solved it by writing this

Code: Select all

[Function(Name = @"user.mypackage.functionname",IsComposable=true)]
        public System.Int32 test([Parameter(Name = "IN_PARAM", DbType = "number(10)")]  System.Nullable IN_PARAM)
        {
            return ((System.Int32)(this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), IN_PARAM).ReturnValue));
       }

[/code]