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.