geomv.c

《Oracle Spatial与OCI高级编程》相关配套源码。介绍了Oracle数据库中的两项关键开发技术Oracle Spatial以及OCI(Oracle Call Interface)。

#ifndef OCI_ORACLE
# include <oci.h>
#endif

sword geomv(OCIEnv *env, OCIError *err)
{
   sword status = OCITypeVTInit(env, err);
   if (status == OCI_SUCCESS)
      status = OCITypeVTInsert(env, err,
         (unsigned char *) "MDSYS", 5,
         (unsigned char *) "SDO_GEOMETRY", 12,
         (unsigned char *) "$8.0", 4);
   if (status == OCI_SUCCESS)
      status = OCITypeVTInsert(env, err,
         (unsigned char *) "MDSYS", 5,
         (unsigned char *) "SDO_POINT_TYPE", 14,
         (unsigned char *) "$8.0", 4);
   if (status == OCI_SUCCESS)
      status = OCITypeVTInsert(env, err,
         (unsigned char *) "MDSYS", 5,
         (unsigned char *) "SDO_ELEM_INFO_ARRAY", 19,
         (unsigned char *) "$8.0", 4);
   if (status == OCI_SUCCESS)
      status = OCITypeVTInsert(env, err,
         (unsigned char *) "MDSYS", 5,
         (unsigned char *) "SDO_ORDINATE_ARRAY", 18,
         (unsigned char *) "$8.0", 4);
   return status;
}