TRUNCATE and DROP Command not working

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

image

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

Should you rather use “Execute Non Query” activity?
Cheers