We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


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

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