DECLARE
	v_udl_pk NUMBER;
	v_errors_allowed NUMBER;
	--var v_sim_count NUMBER;
	--v_track_errors NUMBER;
BEGIN
-- Get the maximum errors allowed parameter
BEGIN
	execute immediate 'SELECT udl.user_data_link_pk INTO :v_udl_pk
	FROM ni_user_data_types udt,
	ni_user_data_link udl
	WHERE udt.user_data_type_pk = udl.related_user_data_type
	AND udt.name              = 'SOP-MAX-ERROR-RECORDS'
	AND udl.object_type       = 60002';
END;
BEGIN
	execute immedate 'SELECT ud.data_value into :v_errors_allowed
	FROM ni_sim_order_ud ud,
	ni_sim_order simo
	WHERE simo.sim_order_pk     = 2
	AND simo.sim_order_pk     = ud.sim_order_fk
	AND ud.user_data_link_fk  = :v_udl_pk';
	DBMS_OUTPUT.PUT_LINE("Errors:"||v_errors_allowed);
END;

END;
/

DECLARE
  v_udl_pk NUMBER;
  v_errors_allowed NUMBER;
BEGIN
  SELECT udl.user_data_link_pk INTO v_udl_pk
  FROM ni_user_data_types udt, ni_user_data_link udl
  WHERE udt.user_data_type_pk = udl.related_user_data_type
    AND udt.name              = 'SOP-MAX-ERROR-RECORDS'
    AND udl.object_type       = 60002;

  SELECT ud.data_value into v_errors_allowed
  FROM ni_sim_order_ud ud, ni_sim_order simo
  WHERE simo.sim_order_pk     = 2
    AND simo.sim_order_pk     = ud.sim_order_fk
    AND ud.user_data_link_fk  = v_udl_pk;
END;