CODEWITHSUNDEEP
stored-proceduresplsql
Patan
Patan

Reputation: 17873

Plsql to run Stored procedure with Custom types as Table

I have stored procedure

PROCEDURE getEmployees(i_employee_forms IN EMPFORMLIST_ID_TYPES, result OUT EMPLOYEELIST)


EMPFORMLIST_ID_TYPES as table of EMPFORM_ID_TYPE;
EMPLOYEELIST as table of EMPLOYEE;

I am trying to write plsql block to execute this.

Can some on hemp me.

Upvotes: 0

Views: 958

Answers (1)

Praind
Praind

Reputation: 1571

Is this what you are looking for?

DECLARE
    employee_forms EMPFORMLIST_ID_TYPES;
    employee_list EMPLOYEELIST;
BEGIN
    employee_forms := EMPFORMLIST_ID_TYPES('variable1', 'variable2', 'variable3');

    getEmployees(employee_forms, employee_list);
END;

Upvotes: 1

Related Questions