Hi ,
I am trying to use this SQL Script using Oracle 12c driver connection :
TRUNCATE TABLE RPA_UNBILLED;
DROP TABLE RPA_UNBILLED PURGE;
While running the same script in Oracle SQL Developer tool its working fine
But I,m getting an error while running through Execute Query activity:
"Execute Query: ERROR [HY000] [Oracle][ODBC][Ora]ORA-03291: Invalid truncate option - missing STORAGE keyword\n

Please advice.
@Raghvendra_Sharma Can you Check if the Table Name in the Database is the Same or not?
1 Like
I am not having visibility to that, I’ll check the same and let you know
Thanks you your response
1 Like
Yes table was not created.
Also when I try to run Truncate and DROP command along with Create Statement, I’m still getting error
So what I have created separate script one for Drop and Truncate
and one for create query.
Thanks
1 Like
J0ska
5
Should you rather use “Execute Non Query” activity?
Cheers
system
(system)
Closed
6
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.