Passing PL/SQL variable into jc_delete

Hi, I need to add a call to the jc_delete proc from PL/SQL. Please could you give me an example of how I can pass a variable into the jc_delete procedure?





The examples in your docs show a literal string in quotes for the WHERE clause:








eg.

Code:

jchem_table_pkg.jc_delete('jc_nci_1m', 'WHERE cd_id > 1800000', null);

Instead of the literal string I would like to use a PL/SQL varchar2 named variable1 in the WHERE clause, something like:

Code:

WHERE  column_name = variable1

Many thanks...

The docs example with a variable "cd_id" of type NUMBER:

Code:

jchem_table_pkg.jc_delete('jc_nci_1m', 'WHERE cd_id > ' || to_char(cd_id), null);