Query for the Tech Type ID
Before you call the API, run the following query to retrieve the local tech type ID for the PL/SQL technology type:
select tech_type_id from cdr_tech_types where tech_name_rc='$TECHTYPES$PLSQL';
Note:
Save the tech type ID for use in creating Source Code definitions as well as the Program definition.
Parent topic: Creating a Program Definition and Instance