Home » Server Options » Spatial » Host Variable?
Host Variable? [message #186883] Thu, 10 August 2006 00:54
cavinlam83
Messages: 24
Registered: August 2006
Location: MALAYSIA
Junior Member

I found that INSERT statement in Oracle SQL has a limit of 999 arguments. Therefore, I cannot create a variable-length array of more than 999 elements using the SDO_GEOMETRY constructor (spatial) inside a transactional INSERT statement; however, I also found that I can insert a geometry using a host variable, and the host variable can be built using the SDO_GEOMETRY constructor with more than 999 values in the SDO_ORDINATE_ARRAY specification.

But the problem is I dun know how to build a host variable using the SDO_GEOMETRY constructor with more than 999 values in the SDO_ORDINATE_ARRAY specification. Can somebody help me?? Thanks.
Previous Topic: ORA-00939: too many arguments for function
Next Topic: Spatial interface to GIS applications
Goto Forum:
  


Current Time: Thu Mar 28 13:28:11 CDT 2024