while migrating objects from Oracle to Vertica, how to consider the Packages/stored procedures.

chak_verticachak_vertica Registered User

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.



  • stalematestalemate Registered User

    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
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file