Oracle ( stored procedure/function with object) Migration to Vertica

Hi everybody. I have a project that requires oracle migration to vertica. One problem we are facing now is clients have a lot of stored procedures that use custom data type and objects. So is there a good approach to deal with this in vertica? I know we need to quite some work when we migrated to vertica, but is there a recommended solution? Thank you so much 

Comments

  • Hi!

    Im afraid without specs for "custom data type and objects" no one can answer to you because its too much abstract :(

    In general: convert your custom data types and objects to string/binary representation and write UDFx that can deal with these objects.

    Regards.

Leave a Comment

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