Oracle procedure to vertica compatible code (with complex business logic)
Posted: Thu Jun 02, 2016 7:47 am
Hi All,
I have few oracle procedures with complex business logic (like lot of loops ,cursors ,merger, many updates,delete ) .
These procedure called via extjs ( and java) from UI dashboard and lot of oltp operations are performed from UI to existing oracle db like multiple updates/delete/merge .
Business requirement is to migrate these oracle procs to vertica compatible sql's with existing functionality means update /merge/insert/delete oprations on vertica DB with UI calls .
can you please help me how to convert typical oracle loops /cursors and in/out parameters to vertica (any kind of pseudo code will be helpful).
can we write all business logic in vsql and call via UI ?
i have tried vertica insert/update operations via java procedure but performance is very poor .
any idea how can we implement this scenario ?
Thanks in advance .
I have few oracle procedures with complex business logic (like lot of loops ,cursors ,merger, many updates,delete ) .
These procedure called via extjs ( and java) from UI dashboard and lot of oltp operations are performed from UI to existing oracle db like multiple updates/delete/merge .
Business requirement is to migrate these oracle procs to vertica compatible sql's with existing functionality means update /merge/insert/delete oprations on vertica DB with UI calls .
can you please help me how to convert typical oracle loops /cursors and in/out parameters to vertica (any kind of pseudo code will be helpful).
can we write all business logic in vsql and call via UI ?
i have tried vertica insert/update operations via java procedure but performance is very poor .
any idea how can we implement this scenario ?
Thanks in advance .