Is stored proceedure stage works in oracle 10G also?

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
Jagan617
Participant
Posts: 42
Joined: Thu Jun 05, 2008 7:37 pm

Is stored proceedure stage works in oracle 10G also?

Post by Jagan617 »

We are upgrading the oracle 8i to 10g database. In the jobs we are using stored proceedure stage. Will the same stage works for 10g also without changing.

Can any one confirm this.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

You should be fine.
-craig

"You can never have too many knives" -- Logan Nine Fingers
sreddy
Participant
Posts: 144
Joined: Sun Oct 21, 2007 9:13 am

Re: Is stored proceedure stage works in oracle 10G also?

Post by sreddy »

Jagan


If the existing stored procedures (Oracle 8i) are working fine in upgraded version Oracle 10G. No need to worry about Stored Procedure stage.
You are just calling Stored Procedure
.


Note: When you compare Oracle 8i with Oracle 10G major changes at Architecture and Frount end Forms development and few SQL side.As per my knowledge no need to worry :D

Jagan617 wrote:We are upgrading the oracle 8i to 10g database. In the jobs we are using stored proceedure stage. Will the same stage works for 10g also without changing.

Can any one confirm this.
SReddy
dwpractices@gmail.com
Analyzing Performance
Post Reply