Description of parameters

SQL> insert into jc_idx_udop values('operator_name', 'java_class_name', 'separator', 'params_list');

Parameters:

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` column 1.: 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` column 1.: "fromMyOp" 2.: "one_param"
`my_op(cd_smiles, cd_molweight)`	`'$1{SEP}two_params{SEP}$2'`	0.: actual value of the `cd_smiles` column 1.: "two_params" 2.: actual value of the `cd_molweight` column

Do you have a question? Would you like to learn more? Please browse among the related topics on our support forum or search the website. If you want to suggest modifications or improvements to our documentation email our support directly!