Home » SQL & PL/SQL » SQL & PL/SQL » ORA-14007
ORA-14007 [message #215865] Wed, 24 January 2007 02:09 Go to next message
stockboy
Messages: 1
Registered: January 2007
Location: Belgium
Junior Member
This script (should) drop an index (not with sqlplusw but with oledb)
But I get this error: ORA-14007
Found on internet 'bout ORA-14007:
Cause
keyword LESS missing
Action
supply missing keyword

Where do I have to supply the missing keyword, I don't get it...

Can you guys help me out here?
(this is a newbee talkin')


********** AutoIt-script ********

; Create a COM ADODB Object with the Beta version
$ado = ObjCreate( "ADODB.Connection" )
With $ado
.ConnectionString =("Provider='OraOLEDB.Oracle';Data Source=" & $SID & ";User Id='parnassus';Password='xxxxx';")
.Open
EndWith

; Create a Record Set to handles SQL Records
$adors = ObjCreate( "ADODB.RecordSet" )
With $adors
.ActiveConnection = $ado
.Execute ("drop index prn_tekst_idx01")
.Open
EndWith

; Write to log
While not $adors.EOF
For $i = 0 To $adors.Fields.Count - 1
FileWriteLogOracle($pad6 &"Parn_060204.log",$adors.Fields( $i ).Value & @TAB)
Next
$adors.MoveNext
WEnd

********** AutoIt-script ********
Re: ORA-14007 [message #235165 is a reply to message #215865] Fri, 04 May 2007 03:57 Go to previous messageGo to next message
orasupport
Messages: 11
Registered: May 2007
Junior Member
Try with "ADODB.Command"?
Re: ORA-14007 [message #235166 is a reply to message #215865] Fri, 04 May 2007 04:01 Go to previous messageGo to next message
orasupport
Messages: 11
Registered: May 2007
Junior Member
$ado.Execute("drop index prn_tekst_idx01")
instead of
$adors.Execute("drop index prn_tekst_idx01")


Re: ORA-14007 [message #235182 is a reply to message #235166] Fri, 04 May 2007 04:26 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Please stop digging up old threads.

MHE
Re: ORA-14007 [message #235218 is a reply to message #235182] Fri, 04 May 2007 06:45 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

We have a cleanup boy ? Rolling Eyes
Previous Topic: table content comparison
Next Topic: Call Web Service (WSDL) in Oracle 8i
Goto Forum:
  


Current Time: Tue Dec 06 00:14:57 CST 2016

Total time taken to generate the page: 0.10386 seconds