As a brief note, this is probably not the best list for this. You would do
better to ask questions like this on -general where you have more
application developers and so forth. This is more of an SQL question so
asking people who are hacking the codebase may not be the best way to get
it
Hi,
App is moving to Postgre from Oracel . After migrating the store procedure
is throwing an error with collection type.
*Oracle :*
create or replace PROCEDURE"PROC1"
(
, REQ_CURR_CODE IN VARCHAR2
, IS_VALID OUT VARCHAR2
, ERROR_MSG OUT VARCHAR2
) AS
TYPE INV_LINES_RT IS RECORD(