cancel
Showing results for 
Search instead for 
Did you mean: 

Copy Data from virtual table to another virtual table.

Former Member
0 Kudos

Hi guys,

Here is a scenario in which I'm having data in one virtual table named 'VT1'. This VT1 table is getting updated by one CV.

My requirement is to update an another virtual table named 'VT2' from the data available in table VT1. Both the table is having same structure.

I tried to use a simple INSERT statement which is

INSERT INTO "VT2" (SELECT * FROM "VT1");

But this statement is giving error like..... SAP DBTech JDBC: [403]: internal error: Error executing query [Oracle][ODBC]Invalid datetime format. for query " INSERT INT......"

VT1 table definition is like Field1(varchar 56), Field2(varchar 100), Field3(timestamp), Field4(varchar 2000), Field5(varchar 2000), Field6(timestamp), Field7(varchar 2000), Field8(varchar 80), Field9(timestamp),Field10(varchar 80), Field11(timestamp)

Any suggestions here, expert lars.breddemann thomas.jung? Sincere thanks in advance.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member428787
Discoverer
0 Kudos

Good morning Friend, did you solve this error?
I have the same problem.

0 Kudos

Hi Saurabh,

for me it seems like the schema of VT1 is not exactly matching the one of VT2. (Column Names, Datatypes etc.)

Can you please have a look at that? It might be that you need to do some transformation ontop of VT1 so that it produces valid output for VT2.

Thanks,

Timo Wagner