-- Enable DBMS_OUTPUT to see output in SQL DeveloperSET SERVEROUTPUT ON;
-- Declare a block to execute the procedureDECLARE    p_emp_cur SYS_REFCURSOR; -- Cursor to hold the output result setBEGIN    -- Call the procedure within the package    metadata_pkg.employee_pred_search(        searchtext   => '', -- Replace with your search text        resultcount  => 5,          -- Adjust the number of results if needed        p_emp_cur    => p_emp_cur   -- Output cursor    );
    -- Display the cursor contents directly in SQL Developer    DBMS_SQL.RETURN_RESULT(p_emp_cur);
END;/

-- Define variables to hold the output data from the procedureDECLARE    p_emp_cur SYS_REFCURSOR; -- Cursor to hold the output result setBEGIN    -- Call the procedure within the package    metadata_pkg.employee_pred_search(        searchtext   => 'your_search_text', -- Replace with your search text        resultcount  => 5,                   -- Adjust the number of results if needed        p_emp_cur    => p_emp_cur            -- Output cursor    );
    -- Fetch and display the results from the cursor    FOR rec IN (p_emp_cur) LOOP        DBMS_OUTPUT.PUT_LINE('Record: ' || rec.column_name); -- Adjust column_name to match your table structure    END LOOP;        -- Close the cursor    CLOSE p_emp_cur;END;/
-- Enable DBMS_OUTPUT to see output in SQL DeveloperSET SERVEROUTPUT ON;