on 11-24-2016 3:39 PM
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.
Good morning Friend, did you solve this error?
I have the same problem.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.