Issue with executing proc statement in toraclesp

[Anonymous]

Hello Guys
I am facing same issue with executing proc in toraclerow
my statement is something like 
"begin 
execute KNVDEVPOC.XDLU_LOAD_CATALOGENTRIES.PREPROCESS_DATALOAD;
end;
"
Error:  PLS-00103: Encountered the symbol "KNVDEVPOC" when expecting one of the following:
   := . ( @ % ; immediate
The symbol ":=" was substituted for "KNVDEVPOC" to continue.
Thanks
VH

[Anonymous]

Hi VH,

Error:  PLS-00103: Encountered the symbol "KNVDEVPOC" when expecting one of the following:
   := . ( @ % ; immediate
The symbol ":=" was substituted for "KNVDEVPOC" to continue.

There is a syntax error in your statement. Can you successfully use it in your oracle client?
Best regards
Sabrina

[Anonymous]

Hello Sabrina

I have tried another syntax for executing parametrized proc in toraclerow as above one is not running but still faced nullpointer error however i can run the same with oracleclient (sql developer).
BEGIN
KNVDEVPOC.XDLU_LOAD_CATALOGENTRIESS.EXECUTE_XDLU(1);
END;

Error: Exception in component tOracleRow_1
java.lang.NullPointerException
at catalogfeeder_1.catalogfeederetl_process_run_0_1.CatalogFeederETL_Process_run.tOracleRow_1Process(CatalogFeederETL_Process_run.java:9041)

Please help.

[Anonymous]

Hi,
Could you please post your current job design screenshot into forum? Did you use tOracleConnection component in your work flow?
Best regards
Sabrina