Execute an oracle stored procedure via initSql

Thread is closed for posting
2 posts, 0 answers
  1. Marco
    Marco avatar
    6 posts
    Member since:
    Aug 2011

    Posted 27 Feb 2013 Link to this post

    Hi there!
    I am stuck with calling a simple oracle stored procedure in <initSql /> in backendconfiguration.
    Already tried the following variants without any effect:

    <!-- ORA-00900 -->
    <initSql>DBMS_APPLICATION_INFO.SET_MODULE('mymodule', 'myaction');</initSql>
    <initSql>DBMS_APPLICATION_INFO.SET_MODULE("mymodule", "myaction");</initSql
    <initSql>EXECUTE DBMS_APPLICATION_INFO.SET_MODULE('mymodule', 'myaction');</initSql>
    <!-- ORA-06550 && PLS-00801: internal error [22503] -->
    <initSql>EXEC DBMS_APPLICATION_INFO.SET_MODULE('mymodule', 'myaction')</initSql>
    <initSql>EXEC DBMS_APPLICATION_INFO.SET_MODULE('mymodule', 'myaction');</initSql>
    <initSql>EXEC DBMS_APPLICATION_INFO.SET_MODULE('mymodule', 'myaction');COMMIT</initSql>

    How can it be done?
  2. Damyan Bogoev
    Damyan Bogoev avatar
    581 posts

    Posted 01 Mar 2013 Link to this post

    Hello Marco,

    I am afraid that currently neither code blocks nor PL/SQL can be used in this scenario.

    We will consider them as a future improvement in the product.

    Damyan Bogoev
    the Telerik team
    OpenAccess ORM Q1 2013 is out featuring Multi-Diagrams, Persistent Data Stream Support and much more. Sign up for a free webinar to see all the new stuff in action.
Back to Top