Very Computer

>Hi,
>I'm looking into Oracle8 compatibility with our current Oracle 7.3 for NT
>database.  I have a few questions that I'm hoping someone can answer.  I
>read about  LOBs (Large Binary Objects) and wondered if Oracle8 still
>supports the Long Raw datatype.  We have several tables using Long Raw and

>On 2 Oct 1997 13:28:16 GMT, "Greg Westendorf"

>>Hi,
>>I'm looking into Oracle8 compatibility with our current Oracle 7.3 for NT
>>database.  I have a few questions that I'm hoping someone can answer.  I
>>read about  LOBs (Large Binary Objects) and wondered if Oracle8 still
>>supports the Long Raw datatype.  We have several tables using Long Raw and

>Yes they are still supported, no datatypes have been removed.  LONGS and LONG
>RAWS are still supported in the same manner as before.

>>a change in that data type translates to a change in the VB code.
>>Also, is there any problem with Net8 connectivity?  Is it compatible with
>>16-bit VB/Access programs?
>>In general are there any pitfalls or horror stories I should know about?

>Net8 is backwards compatible with sqlnet2.  The Net8 listener will accept
>sql*net 2 client connections.

>>TIA
>>greg

>Thomas Kyte

>Oracle Government
>Bethesda MD

>http://govt.us.oracle.com/    -- downloadable utilities

>----------------------------------------------------------------------------
>Opinions are mine and do not necessarily reflect those of Oracle Corporation

>Mildly tangental to Greg's question:

>I've experienced problems with the sql*plus describe command in Oracle8.
>Specifically, when I try to describe *ANY* V$ table, Oracle8 claims it
>doesn't exist.  If I describe sys.v$_session it works, but describing
>v$session fails.  Is this a bug or a misfeature?  I've checked it out, and
>it's endemic to public synonyms...even if you're the owner of the base
>table.  I've been to lazy to try using OCI or dbms_sql to describe a public
>synonym, but I hope like hell it's just sql*plus that's broken.

>Robert

>PS:  I haven't ruled out the possibility of a hosed up install either.

>>On 2 Oct 1997 13:28:16 GMT, "Greg Westendorf"

>>>Hi,
>>>I'm looking into Oracle8 compatibility with our current Oracle 7.3 for NT
>>>database.  I have a few questions that I'm hoping someone can answer.  I
>>>read about  LOBs (Large Binary Objects) and wondered if Oracle8 still
>>>supports the Long Raw datatype.  We have several tables using Long Raw and

>>Yes they are still supported, no datatypes have been removed.  LONGS and LONG
>>RAWS are still supported in the same manner as before.

>>>a change in that data type translates to a change in the VB code.
>>>Also, is there any problem with Net8 connectivity?  Is it compatible with
>>>16-bit VB/Access programs?
>>>In general are there any pitfalls or horror stories I should know about?

>>Net8 is backwards compatible with sqlnet2.  The Net8 listener will accept
>>sql*net 2 client connections.

>>>TIA
>>>greg

>>Thomas Kyte

>>Oracle Government
>>Bethesda MD

>>http://govt.us.oracle.com/    -- downloadable utilities

>>----------------------------------------------------------------------------
>>Opinions are mine and do not necessarily reflect those of Oracle Corporation

> Mildly tangental to Greg's question:

> I've experienced problems with the sql*plus describe command in Oracle8.
> Specifically, when I try to describe *ANY* V$ table, Oracle8 claims it
> doesn't exist.  If I describe sys.v$_session it works, but describing
> v$session fails.  Is this a bug or a misfeature?  I've checked it out,
and
> it's endemic to public synonyms...even if you're the owner of the base
> table.  I've been to lazy to try using OCI or dbms_sql to describe a
public
> synonym, but I hope like hell it's just sql*plus that's broken.

> Robert

> PS:  I haven't ruled out the possibility of a hosed up install either.

> >On 2 Oct 1997 13:28:16 GMT, "Greg Westendorf"

> >>Hi,
> >>I'm looking into Oracle8 compatibility with our current Oracle 7.3 for
NT
> >>database.  I have a few questions that I'm hoping someone can answer.
I
> >>read about  LOBs (Large Binary Objects) and wondered if Oracle8 still
> >>supports the Long Raw datatype.  We have several tables using Long Raw
and

> >Yes they are still supported, no datatypes have been removed.  LONGS and
LONG
> >RAWS are still supported in the same manner as before.

> >>a change in that data type translates to a change in the VB code.
> >>Also, is there any problem with Net8 connectivity?  Is it compatible
with
> >>16-bit VB/Access programs?
> >>In general are there any pitfalls or horror stories I should know
about?

> >Net8 is backwards compatible with sqlnet2.  The Net8 listener will
accept
> >sql*net 2 client connections.

> >>TIA
> >>greg

> >Thomas Kyte

> >Oracle Government
> >Bethesda MD

> >http://govt.us.oracle.com/    -- downloadable utilities

>---------------------------------------------------------------------------
-
> >Opinions are mine and do not necessarily reflect those of Oracle
Corporation