From: "Aaron D. Hager" <adhager@onebox.com>
Newsgroups: comp.databases.oracle.misc
Subject: OCI create index
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Message-ID: <A4wZ5.5150$Oz5.500080@typhoon2.ba-dsg.net>
Date: Tue, 12 Dec 2000 20:42:08 GMT
NNTP-Posting-Host: 141.155.42.145
X-Complaints-To: newsadmin@bellatlantic.net
X-Trace: typhoon2.ba-dsg.net 976653728 141.155.42.145 (Tue, 12 Dec 2000 15:42:08 EST)
NNTP-Posting-Date: Tue, 12 Dec 2000 15:42:08 EST


I am using OCIStmtExecute() to create indexes using the following commands
CREATE INDEX oracle.SIALABM_IN_HOLDMOBAGSTBAG2 ON
oracle.SIALABM_IN_HOLDMOBAGST(BAG2D,BAG1)
CREATE INDEX oracle.SIALABM_IN_HOLDMOBAGSTBAG3 ON
oracle.SIALABM_IN_HOLDMOBAGST(BAG3D,BAG1)

for some reason it is truncating the names of the indexes to
SIALABM_IN_HOLDMOBAGST

The commands work properly if entered in SQL*Plus.

Any ideas?

Thanks,

Aaron