Re: Oracle7 & Hypercard ???

In article <36ut19$gma_at_tycho.gartner.com> Yippee, jdutta_at_gartner.com writes:
>One of our Oracle databases still under Version 6 needs to be migrated
>to Version 7. One of the obstacles is a Hypercard application which
>currently runs against V6. In doing a straight porting, we found some
>SQL statements which worked against Oracle6 do not against Oracle7.
>* Does anybody have experience in porting a Hypercard/Oracle6
>application to Hypercard/Oracle7 ?
>* If so, what are the things we should look out for ?
>Any information or leads would be greatly appreciated.

The Oracle Access drivers which are used to created the execsql XCMD are designed for Oracle 6. They do not know how to handle the new Oracle7 datatypes, they do not know how to call stored procedures, etc.

The easiest way to determine if something will work or not (and how to fix
it), is by trying to use SQL*DBA 6.0.xx or SQL*Plus 3.0.xx against your V7
database. Use these tools to enter the exact SQL statements you are trying
to execute in HyperCard (converting execsql syntax into sql syntax, of course). If these statements work in these tools, then they should work in
HyperCard

Oracle Glue -- which supplants Oracle Access -- will be available for the Macintosh "Real Soon Now." According to our Official Statement of Direction, it is scheduled for an October/November '94 release. Oracle Glue will allow you to fully access an Oracle7 database and will help avoid the hassle of trying to get a V6 client to speak intelligently to a V7 database.

Hope this helps,
--Doug
Doug Bitting || Oracle Corporation || dbitting_at_oracle.com Worldwide Technical Support || Apple Desktop Products Group All opinions expressed in this article are my own and may not

           reflect those of Oracle Corporation. Received on Thu Oct 06 1994 - 16:26:30 CET