topic Re: Issue with executing proc statement in toraclesp in Talend Studio

Issue with executing proc statement in toraclesp

Anonymous — Mon, 02 Jan 2017 09:17:02 GMT

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

Re: Issue with executing proc statement in toraclesp

Anonymous — Tue, 03 Jan 2017 08:18:36 GMT

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

Re: Issue with executing proc statement in toraclesp

Anonymous — Tue, 03 Jan 2017 10:31:24 GMT

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.

Re: Issue with executing proc statement in toraclesp

Anonymous — Wed, 04 Jan 2017 07:37:49 GMT

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