-
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?
-
Try this:
kgl_deptexp_Load('PPLI'||','||'PPNC', '9999', 'AC')
Hope this will help.
Take care
-
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.
-
kgl_deptexp_Load('PPLI'||','||'PPNC', '9999', 'AC')
will work fine just like mber has mentioned above.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|