| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
