Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> execute immediate with User Defined Types
Hi
Does anyone know a work-a-round to allow User defined types to be passed To & From PL/SQL blocks using Execute Immediate? (Or Another way to do the same.)
TYPE InfoBlock IS RECORD ( ..... );
Status Number;
IBlock InfoBlock;
execute immediate 'BEGIN ' || 'UserFunc(:1,:2)' || '; END;'
using IN OUT Status, IN OUT IBlock;
TIA Received on Mon Jun 06 2005 - 07:51:02 CDT