Oracle functions in universe

[Former Member]

Hi Experts ,

I have created a set of user defined functions in oracle .I included these functions in Oracleen.PRM file . I restarted all the servers . Still i did not see my function in the universe . My functions has two parameters . I need to pass two universe objects as a parameters to this function .

Please let me know the syntax for my select query and I would like to use this functions in WEBI .

Many thanks in advance.

Regards,

Dirasa

[Former Member]

Hi,

You need to add your function in "oracle.prm" file in order to have the exact syntax.

Write your function such as the below sample:

<Function Group="False" ID="MyFunction" InMacro="True" Type="String">
            <Arguments>
                <Argument Type="String"></Argument>
                <Argument Type="Number"></Argument>
            </Arguments>
            <SQL>MyFunction($1,$2)</SQL>
        </Function>

By the way, it is not mandatory to have the function described in the prm file to use it in SQL expressions.

The prm file is just a helper for writing SQL.

Regards

Didier

[Former Member]

Mazoue ,

My function works well with out editing any parameter file .I just wrote the same syntax in the Oracle.PRM file . I restarted all the BO 3.1 servers .

But this effecting my BO designer 3.1 . When ever i click on PARSE button in object definition ,My designer terminating unexpectedly with visual studio just in time debbuger error.

Any idea on this ?

Thanks for keeping my post alive .

Regards,

Dirasa