Oracle: copy_to with overwrite fails

[tidyverse]

Oracle: copy_to with overwrite fails

@krlmlr commented on Jan 17, 2018, 7:51 AM UTC:

Thanks for reporting this. Is there an equivalent to DROP TABLE IF EXISTS in Oracle?

@EdwardJRoss commented on Jan 17, 2018, 11:30 PM UTC:

Unfortunately only a messy one, try to drop the table and catch the "table not exists error" if it is thrown.

BEGIN
   EXECUTE IMMEDIATE 'DROP TABLE <the table>';
EXCEPTION
   WHEN OTHERS THEN
      IF SQLCODE != -942 THEN
         RAISE;
      END IF;
END;

@krlmlr commented on Jan 18, 2018, 12:30 PM UTC:

Thanks. This could be good enough for dbplyr, if we can't do any better.

@hadley commented on May 20, 2018, 2:34 PM UTC:

@edgararuiz do you want to take this one?

@edgararuiz commented on May 22, 2018, 11:02 PM UTC:

Yes, I'll take this one

[hadley]

Fixed by #85