Skip to Main Content
Forums

Programming Languages & Frameworks

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!

insert table data from one database to another database

ArvindcbgJan 15 2018

Hello guys,

I want to insert data from local database table to remote database table using JDBC connection.

here local database is 8i

and remote database is 12c.

Is their any java script for the purpose.

Thanks in advance.

Arvind

Comments

Srix
did u try changing the filter to SQL ? and specify your variables ..
1 person found this helpful
Albert_Giralt
Thanks for your input, it was very helpful.

I did try to use a SQL filter and it worked fine.

"Tiempo"."Dia (Cod)" between valueof(Var_Dia_Ini) and valueof(Var_Dia_Ant)

Anyway, this is not something I can ask my users to do on a regular basis. Previous versions of OBIEE allowed them to use report variables when filtering dates, same they do for filtering other types of fields. The fact that it does not work for dates makes think this is a new bug introduced in 11.1.1.6 (or maybe even 11.1.1.5).
Srix
Seems like a bug for me .. You should open an SR

~Srix
Albert_Giralt
Yes, that I did.

I will let you know when they give me some solid info on this issue.
Albert_Giralt
As we have already guessed, it is a known bug.

Bug 13886662: OBI 11.1.1.6 DATE FILTER: THE VALUE ENTERED MUST BE A DATE AND TIME IN THE FORM

Weird it didn't pop up on the searches I did.

Well, I can only hope it will gte fixed ASAP.

I am marking this question as answered, since there is really little that can be done until it's fixed.
1 - 5

Post Details

Added on Jan 15 2018
#javascript-nashorn
0 comments
455 views