Porting Oracle programs and sub-procedures to postgres

Question

For a client asking to port Oracle packages to postgres I have procedures of over 5K lines of code with some having like X cursors and 40 sub procedures on the inside. something like:

PROCEDURE procedure_name(var_name var_type, var_name var_type OUT)
   CURSOR cursor_name
   CURSOR cursor2_name
   sub PROCEDURE sub_procedure_name(vars)
   end sub_procedure_name(vars)
   sub PROCEDURE sub_procedure_name(vars)
   end sub_precodeure_name

--BEGINNING OF MAIN PROCEDURE
end main_procedure

Currently I'm taking every package, subdeviding every main procedure into its subprocedures in separate files.

however i have no clue about the final structure of the project in plpgsql.

I want to know if i can nest functions and procedures inside of procedures in plpgsql.

A novel suggestion; Try it; just write a simple procedure/function with a simple nested procedure/function. — Belayer
– Belayer, Commented Aug 25, 2021 at 21:58

Pavel Stehule · Accepted Answer · 2021-08-26 03:57:42Z

1

No, you cannot. PostgreSQL has not this feature. You have to rewrite your code.

answered Aug 26, 2021 at 3:57

Pavel Stehule

46.6k6 gold badges103 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Porting Oracle programs and sub-procedures to postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related