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
0
Comments
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.