How to call a procedure from a wordpad

[_AnonymousUser]

Hi team,
I need to run a stored procedure using jasper. Code should be given in the job (say, it can be given in tfileInputDelimited). So that, the code should be fetched by the database and should be run. toraclesp components calls a stored procedure which is already created in db. But i need to create a proc using the code which is to be given by me in the job. Is this possible? Thanks in advance

Regards,
Hermione

[Anonymous]

Hello Guys
I am facing same issue with executing a parametrized proc in toraclerow
my statement is something like 
BEGIN
KNVDEVPOC.XDLU_LOAD_CATALOGENTRIESS.EXECUTE_XDLU(1);
END;
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
Thanks
VH