How to pass a comma as part of a PL/SQL Block Parameter?

[kbissing]

These are the parameters I am trying to pass to my SQL Block.
They are:
Ledger: PPLI','PPNC
Department: 9999
DataType: AC
When executing it from SQL Plus, I tried:
kgl_deptexp_Load("PPLI','PPNC", "9999", "AC")


I get the following error message:
ORA-06550: line 1, column 24:
PLS-00201: identifier 'PPLI','PPNC' must be declared
ORA-06550: line 1, column 7:

Any ideas??
Thanks in advance!
Kim

What is the correct way to pass in this parameter?

[mber]

Try this:

kgl_deptexp_Load('PPLI'||','||'PPNC', '9999', 'AC')


Hope this will help.

Take care

[mary]

You will have to edit the previous example.
Try to play with someting like this:

chr(34)||'PPLI'||chr(39)||','||chr(39)||'PPNC'||chr(34)
Example of output
1* select chr(34)||'PPLI'||chr(39)||','||chr(39)||'PPNC'||chr(34) argument from dual
SQL> /
ARGUMENT
-------------
"PPLI','PPNC"

or something like this:
'PPLI'||chr(39)||','||chr(39)||'PPNC'
Example of output
SQL> select 'PPLI'||chr(39)||','||chr(39)||'PPNC' argument from dual;
ARGUMENT
-----------
PPLI','PPNC
Look up Orcle chr() function. Post additional question here if you need more help.

[arshiah]

kgl_deptexp_Load('PPLI'||','||'PPNC', '9999', 'AC')
will work fine just like mber has mentioned above.