Invoking JAVA STORED PROCEDURES

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
srinivasb
Participant
Posts: 42
Joined: Mon Mar 10, 2003 10:52 pm
Location: UK
Contact:
Contact srinivasb

Invoking JAVA STORED PROCEDURES

Post by srinivasb »

Hi everyone,

Am trying to understand the means and methods of invoking Java Stored Procedures from Oracle Database - 8i/9i.

Has any one done this before ? To give you a brief background,all calculations are written in JSP and invoked by the ETL tool - DataStage Ver 5.2.

Please immediately reply me with your resources.... AM ON A REAL TIME WARP.
Regards
Srinivas.B

Srinivas.B
India
Mobile :0091-44-2301101
Xtn 35
Top
kww
Participant
Posts: 18
Joined: Thu Dec 12, 2002 9:17 pm

Post by kww »

See the reply for the other oracle stored procedure topic. You could have a wrapper function (pl/sql call spec) to call your java stored procedure. It works.
Hi everyone,

Am trying to understand the means and methods of invoking Java Stored Procedures from Oracle Database - 8i/9i.

Has any one done this before ? To give you a brief background,all calculations are written in JSP and invoked by the ETL tool - DataStage Ver 5.2.

Please immediately reply me with your resources.... AM ON A REAL TIME WARP.
Regards
Srinivas.B

Srinivas.B
India
Mobile :0091-44-2301101
Xtn 35
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”