Re: is the CHAR pl/sql variable type being pushed out

hap_at_mikomi.org (Adam Hapworth) wrote in message news:<a6cb04db.0206140846.3e72d61c_at_posting.google.com>...
> We run a shop on Oracle 8.16 and currently forms 4.5. I do most of my
> work with a text editor (emacs) writing server side
> procedures/functions. We are going to be upgradinag to developer 2000
> some day soon. My supervisor and I got into a little tiff this
> morning about the use of CHAR variable types in pl/sql. He is saying
> that they are no longer supported and I am saying they are. He uses
> procedure builder and forms 6 often which he says dosen't let him use
> the char type. Where as I do almost all of my code serverside with my
> text editor. My code with CHAR types in it compiles fine and runs
> good. The current project I have requires the use of a large number of
> fixed length fields for which I am using the CHAR variable type. I
> would like to be certain that in future releases of Oracle that the
> CHAR varaible type will still be around or if it will be replaced.
>
> Thanks
> Adam

I've never seen any desupported notice.
Between Oracle 6 and Oracle 7 the char datatype became fixed instead of variable and the default character datatype became varchar2. This change was reflected in Forms, which definitely doesn't mean you can't use char anymore. Not that you shouldn't because of the change in meaning.
I think your supervisor should come up with a formal desupport notice, it looks like he is currently relying on hearsay and on trouble to work with Forms 4.5

Hth

Sybrand Bakker
Senior Oracle DBA Received on Sat Jun 15 2002 - 17:04:18 CEST