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.

Report message to a moderator

Previous Topic: ORA-00939: too many arguments for function
Next Topic: Spatial interface to GIS applications
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 28 06:17:44 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.