How to call a PL/SQL procedure that takes a custom type as a parameter?

Question

I have the following (I can't change it, it is provided for me to use):

TYPE Person_Rec IS RECORD(
ID NUMBER(10),
Name VARCHAR2(30),
Age Number(10));

PROCEDURE Modify_Person(rec IN Person_rec, option IN NUMBER)
IS
BEGIN
...
END;

How would I call Modify_Person externally, using some SQL statement - from an SQL console or C++, etc? How Do I wrap parameters into a Person_Rec?

Answer 1

I don't see any easy way of doing it from C++ or from an SQL console. I recommend you create a wrapper package, and add a procedure like so:

    PROCEDURE MyPackage.Modify_Person(id IN NUMBER, 
                                      name IN VARCHAR2, 
                                      age IN NUMBER, 
                                      option IN NUMBER)

and call the original procedure from within the wrapper.