Paasing connection details as parameters
Posted: Tue Jul 07, 2009 5:26 am
Hi,
I am trying to call a oracle stored procedure using a "Stored procedure" stage in a parallel job.
When I tried to call procedure by giving the username and password directly, it is working fine.
But if I parameterize the username and password and try calling the proc I am getting an error "Stored_Procedure_1,0: Error occurred in call to ORPHCallActivePluginInitialize()."
Can anyone tell me if we can parameterize the username and password and pass it in a "Stored procedure" stage?
Thanks in advance...
Krishna
I am trying to call a oracle stored procedure using a "Stored procedure" stage in a parallel job.
When I tried to call procedure by giving the username and password directly, it is working fine.
But if I parameterize the username and password and try calling the proc I am getting an error "Stored_Procedure_1,0: Error occurred in call to ORPHCallActivePluginInitialize()."
Can anyone tell me if we can parameterize the username and password and pass it in a "Stored procedure" stage?
Thanks in advance...
Krishna