while migrating objects from Oracle to Vertica, how to consider the Packages/stored procedures.
We are working on a task to migrate oracle database to vertica. Need suggestion in coverting the packages or stored procedures from oracle to vertica. Do we have any feature to use for this in Verica.
0
Comments
Oracle packages are not supported by Vertica while Oracle stored procedures could basically be converted to Vertica external procedures. You might best be off redesigning your Oracle code in terms of UDF's which translate straightforwardly to Vertica UDF's.