Sachin Srivastava wrote: > In my function the problem is that global variables defined inside the > function. > These variables are visible to functions defined inside a function. > If we move these inner functions to outside of the main function, > they will lose the visibility of the global variables. > So I think that's why we have to correct this functions rather then creating > it as individual.
I see. You'll have to rewrite the functions then, probably by passing the shared values as parameters instead of having them in global variables. > We have migrated our data from Oracle to Postgres through ORA2PG Tool > after that we are getting this error for this function. ora2pg cannot translate all PL/SQL code, you have to be prepared to rewrite most nontrivial functions. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
