[SOLVED] Open Session command in datasource not working

[calson33]

Hi All,

I put in an XML command block into the open session section of a datasource to an Oracle Database.

<commandBlock>
<commands>
<sqlCommand>
<sql>BEGIN ODSMGR.JA_TEST_VALUE('BBBBBB'); END;</sql>
</sqlCommand>
</commands>
</commandBlock>

It's a simple procedure that inserts a value into a table - Just using it for testing.

I created a simple report using custom SQL using that data source which selected from that test table.

However, it never seems to get executed. Nothing is ever put into the table, but I can run the procedure through SQL Developer.

Any thoughts on what I am missing?

Thanks!
John

[calson33]

Duh - I just needed to restart the services.  :-[

[Suraj]

Thanks for letting us know. ;)