Hi fellow users.
Anyone has this same problem before:
Connector reply error: ErrorSource: Microsoft OLE DB Provider for Oracle, ErrorMsg: Unspecified error
I tried to re-run the SQL script using Toad that is connected to the server and database. It worked fine over there.
Hearing from any expert soon.