Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Active Sessions in BEA WebLogic Server ORACLE CC & B

961366Dec 3 2012 — edited Dec 3 2012
Dear Sir,

We have BEA weblogic server and having 12 nodes. We want to check the number of active sessions of Oracle CC & B for each and every hour.
I would request you to provide any help on this.

Regards,
Prasad

Comments

DecaXD
HI,

change your varchar2( X BYTE) to varchar2(X CHAR). This is a characterset issue.

Let us know
zoran_2000
Hello,

if you click on the A column in the target pane, you see the mapping implementation in the Property Inspector.
For example TABLE.A change this in RTRIM(TABLE.A,' ')
Rtrim delete extra blank space .
you can use others SQL function.

Let us know
SVAR
Hi,

Thanks for that.It works if i change it to NVARCHAR2,The only thing is, if target database team in case if they are not willing to change the data type, it it anyway can i do this nvarchar2 to varchar2 conversion?
i.e i can load it into temp table which will have NVARCHAR2 Type and then anyway can it conver it to VARCHAR2 when i load using ODI?

I do not not want to Apply TRIM because if we reach max lenth we will fail when the text strings get closer to the 100 Byte(current length of the column) limit in this case.

Any ideas of converting from NVARCHAR2 TO VARCHAR2?

Cheers
DecaXD
Hi,

here a description

2523159

the issue is due that some char occupy more bytes than another. If you are not working on a Worldwide application usually is sufficient to set a correct charset in your loading procedure.
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 31 2012
Added on Dec 3 2012
1 comment
150 views