Page tree
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}):

operatorparameters listdoFunc 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