Skip to main content

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

  • February 19, 2015
  • 1 reply
  • 10 views

Christine_1
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

1 reply

id10t
Forum|alt.badge.img
  • Participating Frequently
  • February 20, 2015
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.