This question is locked. New answers and comments are not allowed.
Hi there!
I am stuck with calling a simple oracle stored procedure in <initSql /> in backendconfiguration.
Already tried the following variants without any effect:
How can it be done?
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?