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.

 

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.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file