Print Page - Set operations in FM datasource Connection properties

Title: Set operations in FM datasource Connection properties
Post by: Desperado on 25 Jul 2007 11:38:16 AM

I have a requirement for a particular datasource to setup client id as 104 globally ...
I thought , Open connection commands or Open session commands will be useful for this (I don't know why exactly they are used for and i haven't used them before )....
i have to run a particular pkg before working with any of the tables or views in that particular database ....

begin
dbms_application_info.set_client_info('104');
end;

i copied and pasted the same in open session commands and it gave me an error , i did the same in open connection commands and i got this error.....

QE-DEF-0432 There are errors in XML document: begin
dbms_application_info.set_client_info('104');
end;
QE-DEF-0433 The XML document in 'Open connection commands' of connection 'CAMID(":")/dataSource[@name='Midevl']/dataSourceConnection[@name='Midevl']' is invalid.

Can anyone tell me if there is any way that i can do this in FM.
Thanks in Advance

Title: Re: Set operations in FM datasource Connection properties
Post by: goose on 25 Jul 2007 04:30:45 PM

can you post the exact xml?

Title: Re: Set operations in FM datasource Connection properties
Post by: Desperado on 26 Jul 2007 09:28:20 AM

Sorry,
I figured out that i have to pass xml to make it work ..... how to convert that command into xml , to make cognos accept it ???

this is the pl/sql command

begin
dbms_application_info.set_client_info('104');
end;

Thanks in advance

Title: Re: Set operations in FM datasource Connection properties
Post by: Desperado on 26 Jul 2007 11:51:54 AM

Okie,

This is what i came up to till now .... i asked our Pl/sql guys to create a function in DB and i'm trying to pass this as open connection command .

<commandBlock>
<commands>
<sqlCommand>
<sql>select apps.fn_xx_set_org_id() from dual </sql>
</sqlCommand>
</commands>
</commandBlock>

but i ended up with an error .... seems some problem with my SQL. here is my error msg.

QE-DEF-0459 CCLException
RQP-DEF-0177 An error occurred while performing operation 'sqlUpdateAttach' status='-9'.
UDA-SQL-0107 A general exception has occurred during the operation "update attach".
ORA-24374: define not done before fetch or execute and fetch

Please tell me how to correct this ....

Thanks in advance .

P.S : I have a work around .. But i want to utilize this open connection/session command in cognos

Title: Re: Set operations in FM datasource Connection properties
Post by: mgibson on 16 Jul 2008 11:25:39 PM

Hi,

did you ever get a solution to your 'ORA-24374: define not done before fetch or execute and fetch' problem?

I'm getting the same error!

Regards
Mick

Title: Re: Set operations in FM datasource Connection properties
Post by: Desperado on 31 Dec 2008 03:13:27 PM

I managed to solve it by creating a function.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: Desperado on 25 Jul 2007 11:38:16 AM