Re: OCI and V7

In article <1992Jun4.010823.22604_at_cognos.com>, nigelc_at_cognos.com (Nigel Campbell) writes:
|> Simple question:
|>
|> Are there any migration issues for a system using OCI with
|> V6 vs V7 ?
|>

There are a few. I'm not sure if they are associated with V7 or new version of OCI. The first is that a null value not handled through an indicator variable will cause the program to fail. I am not sure if this happens an run or compile time. This to me is a good change. Improperly handled null values currently result in incorrect output. I also believe that trying to shove too long of a string into a host variable no longer produces an error. V7 has different datatypes. The old char is now varchar2 and can hold up to 2000 bytes. Char is similar except entries are stored blank padded. I am not sure what impact this has on OCI. Lastly there has been some talk of no longer supporting the "old" OCI call syntax.

                       Ian MacGregor
                       Stanford Linear Accelerator Center
                       (415) 926-3528