Page 1 of 1
Oracle store procedures
Posted: Thu 30 Apr 2009 08:29
by Trixz
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?
Posted: Thu 30 Apr 2009 10:28
by AndreyR
Sorry, this functionality is not available at the moment. We are implementing the Oracle packages support.
Posted: Thu 30 Apr 2009 10:43
by Trixz
Is there any way I can add code for calling functions and storeprocedures in packages when the code been generated?
Posted: Thu 30 Apr 2009 10:57
by Trixz
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]