Eclipse Community Forums: BIRT » Oracle ALTER SESSION with JavaScript

Home » Archived » BIRT » Oracle ALTER SESSION with JavaScript

Oracle ALTER SESSION with JavaScript [message #521101]

Tue, 16 March 2010 09:33

Eclipse User

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 #521172 is a reply to message #521101]

Tue, 16 March 2010 11:48

Eclipse User

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 #521186 is a reply to message #521172]

Tue, 16 March 2010 12:56

Eclipse User

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

Re: Oracle ALTER SESSION with JavaScript [message #521215 is a reply to message #521186]

Tue, 16 March 2010 14:20

Eclipse User

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
>

Previous Topic:	Loading reports from Classpath?
Next Topic:	BIRT migration to EMF?

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Jul 19 22:24:33 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter