SQL & PL/SQL

Hi,

I'm desperately hoping someone can help me work out why my code is failing...

When I run the following code, it fails:

declare
lJob number;
l_dimension varchar2(30) := 'DIM_CCY';
ljobid number := 1;
begin
  DBMS_JOB.SUBMIT(lJob, 'olap_pkg.dimension_job_processing('||l_DIMENSION||','||lJobID||');');
end;

ORA-06550: line 1, column 127:
PLS-00357: Table,View Or Sequence reference 'DIM_CCY' not allowed in this context
ORA-06550: line 1, column 93:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_JOB", line 79
ORA-06512: at "SYS.DBMS_JOB", line 136
ORA-06512: at line 6

But when I run this code, it works:

declare
lJob number;
l_dimension varchar2(30) := 'DIM_CCY';
ljobid number := 1;
begin
  DBMS_JOB.SUBMIT(lJob, 'olap_pkg.dimension_job_processing(''DIM_CCY'''||','||lJobID||');');
end;

Can anyone shed any light on this for me, please?

Message was edited by:
Boneist