This is a migrated thread and some comments may be shown as answers.

Execute an oracle stored procedure via initSql

1 Answer 56 Views
Development (API, general questions)
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Marco
Top achievements
Rank 1
Marco asked on 27 Feb 2013, 12:57 PM
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?

1 Answer, 1 is accepted

Sort by
0
Damyan Bogoev
Telerik team
answered on 01 Mar 2013, 01:33 PM
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.

Regards,
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.
Tags
Development (API, general questions)
Asked by
Marco
Top achievements
Rank 1
Answers by
Damyan Bogoev
Telerik team
Share this question
or