Print Page - [SOLVED] Open Session command in datasource not working

Title: [SOLVED] Open Session command in datasource not working
Post by: calson33 on 02 May 2014 12:18:13 PM

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

Title: Re: Open Session command in datasource not working
Post by: calson33 on 02 May 2014 05:44:15 PM

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

Title: Re: [SOLVED] Open Session command in datasource not working
Post by: Suraj on 05 May 2014 05:09:55 PM

Thanks for letting us know. ;)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: calson33 on 02 May 2014 12:18:13 PM