Call Oracle Procedure from DS Routine??

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Call Oracle Procedure from DS Routine??

Post by admin »

--Next_1074573458---0-202.54.124.178-8544
Content-type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hey Gurs,=0AIm unable to find BCI from DSXChange.com. Even uanble to read F=
orums also in this. I dont know why it is happening. Pls let me know the pr=
ocess of Calling Stored Procedure from DS Routine.=0A=0AThanx in Advance.=
=0A=0ARegards,=0AVenkat.=0A=0AOn Sat, 17 Jan 2004 Ray Wurlod wrote :=0A>1. =
Obtain a licensed ODBC driver for Oracle and configure and test it.=0A>2. =
Search the archives of this list (at www.dsxchange.com) for BCI.=0A>3. Cr=
eate a Routine in DataStage that uses BCI functions.=0A>4. The SQL stateme=
nt that you execute is CALL.=0A
--Next_1074573458---0-202.54.124.178-8544--
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Call Oracle Procedure from DS Routine??

Post by admin »

--Next_1074233495---0-202.54.124.151-24345
Content-type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hey Gurus,=0A=0AIm slowly working on DataStage :-) Pls help me out. Give ur=
openions how to call a Oracle Stored Procedure from DS Routine??=0A=0ARega=
rds,=0AVenkat=0A=0A=0A=0A
--Next_1074233495---0-202.54.124.151-24345--
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Call Oracle Procedure from DS Routine??

Post by admin »

1. Obtain a licensed ODBC driver for Oracle and configure and test it.
2. Search the archives of this list (at www.dsxchange.com) for BCI.
3. Create a Routine in DataStage that uses BCI functions.
4. The SQL statement that you execute is CALL.
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Locked