|
|
On May 28, 2:23 pm, jdrum...@xxxxxxxxxxx wrote:
> I have a customer who has a large installed code base written using
> oratcl3.3 ( oratclsh ) and Oracle 8i on HPUX 11.
> There is a mandatory ( internal ) Oracle upgrade to 10g.
>
> We have installed Oratcl 4.4. but found that Oracle no longer provides
> oratclsh and the existing code has numerous instances of oramsg(rc)
> checks and orafetch calls that expect values instead of return codes.
>
> Obviously..not the optimum solution, but.....the time and resources
> don't exist to re-code all this... so we're looking at running Oratcl
> 3.3 against Oracle 10g. I haven't seen any documents newer than a few
> years old that talk about this.
> Has anyone done it?
>
> Thanks,
> Jim Drummey
The CVS source tree for Oratcl includes a compat/oracompat.tcl file
that you can include in your source code to largely
eliminate the orafetch changes. the oramsg(rc) is a little more
complicated, that would have to be recoded. So many things in 10g
will not be available to you if you keep the old oratcl 3.3 which is
built upon the OCI7 model. You will not be able
to manipulate LOBs for instance and some of the old limitations on
varchar (2000) size will be in force.
A. I can help you recode in a hurry if you need me too.
B. You should not have a problem connecting oratcl 3.3 to 10g if you
keep your old 8i oratclsh and don't recompile it.
C. I've several chapters of my Oratcl e-book completed, I'll email you
a pdf if you hit me at tmh@xxxxxxxxxxxxxxxxxxxxx (won't be able to
send it til monday).
D. oratclsh shell script can be easily created combining tclsh and
package require Oratcl.
For someone knowledgable, the migration from Oratcl 3.3 to 4.4 does
not have to be that painful and 4.4 works just fine with oracle 11g as
well, so you will be ahead of the game.
Contact me personally if you need my assistance.
thelfter@xxxxxxxxx
P.S. (I'm the tmh@xxxxxxxxxx you see sprinkled all over the Oratcl
3.3 code).
-Todd
|
|