HOw to call procedure in Datastage Oracle Stage

[rharik]

HI Guys,
I am using Datastage 7.5 server edition.. I need to know how to call Procedure in Datastage Oracle stage.
It's very urgent .. Please help me .
Thanks in advance ..

Regards,
kris

[ray.wurlod]

Etiquette Note
We don't do urgent here. If you want urgent answers, sign up with your support provider for premium service, and learn the true cost of urgent.
Reconsider your requirement. Is calling a Stored Procedure for every row processed so necessary? It will be very slow. Can you not replicate the functionality in the ETL tool? Have you investigated the Stored Procedure stage? Have you investigated the ODBC stage? Why must it be the Oracle OCI stage?

[ivannavi]

In the documentation you should find something called "Stored procedure stage". It is not installed by default. You will need to install it to every project in which you need to use it. We have been using it successfully for a while. I hope this works in Windows and server edition too. We have unix, parallel.

[kumar_s]

As mentioned, ODBC stage has option to 'Call StoredProc'. Optionally you use use 'Call Storedprocedure(InutArg)' in Before/After Subroutine.

[ray.wurlod]

What kumar_s has in mind, I believe, is not a before/after subroutine (because Call, in the SQL sense, does not work there unless you wrap it in BCI function calls), but probably the Open/Close commands in the OCI stage.

[chulett]

Open/Close for a Parallel job. He meant the 'Before SQL' or 'After SQL' tab of an OCI stage in a Server job can be used to call a stored procedure as long as they don't return anything.

Otherwise, use the STP or Stored Procedure stage which you have in your version.

[kumar_s]

Code: Select all

'Before SQL' or 'After SQL' tab 

That correct... Something got in to my mind.