Oracle Stored Procedure Example

Thread is closed for posting
2 posts, 0 answers
  1. DMC Helpdesk
    DMC Helpdesk avatar
    52 posts
    Member since:
    Nov 2007

    Posted 17 Jun 2010 Link to this post


    I am using the visual designer to model my business entities, and my backend is oracle.The stored procedures are added in the designer code behind automatically and I can see them when I access the db context, but they are always parameterless.For instance i have a test stored procedure called HelloWorld that takes 1 parameter of type varchar, but the intellisense shows 'HelloWorld()'  without parameters.

    I would like to see an example of calling an oracle stored procedure/function that was added to the visual designer.

  2. Damyan Bogoev
    Damyan Bogoev avatar
    581 posts

    Posted 21 Jun 2010 Link to this post

    Hello DMC Helpdesk,

    This seems to be an issue in the stored procedure parameter names handling. When the length of the parameter name is equal to one, the parameter is omitted. Please specify parameters which names are longer than one symbol to workaround this problem. We are already working on the fix, please excuse us for the inconvenience caused.

    You may find useful our code library example for stored procedures, although it uses the old reverse mapping approach, the usage of stored procedures is similar.

    Damyan Bogoev
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Back to Top