SQL> insert into jc_idx_udop values('operator_name', 'java_class_name', 'separator', 'params_list');operator_name: name of the user defined PL/SQL operator with capital letters (IMPORTANT)
java_class_name: name of the external Java class belongs to the operator (exact letters)
separator: separator string to separate parameters in the following list
params_list: Parameters list separated by the separator string. Use $ sign and index to refer to the parameters of the PL/SQl operator or function in sequence. These parameters are sent to the external Java class. The doFunc function of the class gets these parameters as a String array.
Examples (separator is {SEP}):
| operator | parameters list | doFunc gets the array |
|---|---|---|
my_op(cd_smiles) |
'$1' |
0.: actual value of the cd_smiles column |
my_op(cd_smiles, cd_molweight) |
'$1{SEP}$2' |
0.: actual value of the cd_smiles column1.: actual value of the cd_molweight column |
my_op(cd_smiles, cd_molweight, 'param') |
'$1{SEP}$2{SEP}$3' |
0.: actual value of the cd_smiles column 1.: actual value of the cd_molweight column 2.: "param" |
Any other parameter can be defined:
| operator | parameters list | doFunc gets the array |
|---|---|---|
my_op(cd_smiles) |
'$1{SEP}fromMyOp{SEP}one_param' |
0.: actual value of the cd_smiles column1.: "fromMyOp" 2.: "one_param" |
my_op(cd_smiles, cd_molweight) |
'$1{SEP}two_params{SEP}$2' |
0.: actual value of the cd_smiles column1.: "two_params" 2.: actual value of the cd_molweight column |