|
Re: Oracle ALTER SESSION with JavaScript [message #521172 is a reply to message #521101] |
Tue, 16 March 2010 15:48 |
|
Christian,
Can you put this code in a stored procedure and place a hidden table at
the top of the report that calls it?
Jason
Christian Seeling wrote:
> We use BIRT for access to Oracle databases. For some reasons we need to
> alter session settings for each connection:
>
> ALTER SESSION
> SET NLS_DATE_FORMAT =' ...'
> NLS_TERRITORY = America
> CURSOR_SHARING = SIMILAR
> RECYCLEBIN = OFF
>
> As you can see, controlling localization with standard BIRT settings is
> not sufficient for us.
>
> Our software is based on PHP and thus we use BIRT as it is.
> Is it possible to alter oracle session settings using the BIRT
> JavaScript interface only (Data set/data source events)?
>
> Any help is appreciated!
>
|
|
|
|
Re: Oracle ALTER SESSION with JavaScript [message #521215 is a reply to message #521186] |
Tue, 16 March 2010 18:20 |
|
BIRT can call a stored procedure by creating a new dataset and selecting
stored procedure instead of sql query. The syntax for the sp is:
{call procedure-name(arg1,arg2, ...)}
Jason
Christian Seeling wrote:
> Hi Jason,
>
> first of all, thanks for the quick reply!
>
> We like the idea of having a stored procedure in place.
> However, how can a BIRT dataset run such a procedure?
> Are BIRT datasets capable of SQL EXEC or EXECUTE statements?
>
> Thanks in ad,
> Christian
>
|
|
|
Powered by
FUDForum. Page generated in 0.03037 seconds