Set operations in FM datasource Connection properties

[Desperado]

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

[goose]

can you post the exact xml?

[Desperado]

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

[Desperado]

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

[mgibson]

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

[Desperado]

I managed to solve it by creating a function.