Objective : How to print record type values in Oracle PL/SQL . Solution : Step 1: Create package fxgn_sample_pkg . DROP PACKAGE fxgn_sample_pkg ; create or replace PACKAGE fxgn_sample_pkg as TYPE fxgn_sample_rectype IS RECORD ( p_name varchar2(40), p_emp_id number ); type fxgn_sample_table_rectype is table of fxgn_sample_rectype; procedure fxgn_sample_prc ( fxgn_sample_table_rec1 OUT fxgn_sample_table_rectype ); END fxgn_sample_pkg ; / create or replace PACKAGE BODY fxgn_sample_pkg AS PROCEDURE fxgn_sample_prc ( fxgn_sample_table_rec1 OUT fxgn_sample_table_rectype ) IS BEGIN SELECT ename,
by Karkuvelraja Thangamariappan ♠ (@tkarkuvelraja)