Re: ORA-00937 error
From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Mon, 29 Mar 2004 23:03:57 GMT
Message-ID: <xX1ac.30441$Ct5.20975_at_edtnps89>
>> When I run this simple sql statement out of VB 6.0 i get the ORA-00937
>> error.
>>
>> select count(*) as SeqNbr from tca_plant_assgn where empID = '14995'
>> and outage_cd = 'C10BO'
>>
Date: Mon, 29 Mar 2004 23:03:57 GMT
Message-ID: <xX1ac.30441$Ct5.20975_at_edtnps89>
morph wrote:
> jmeitz_at_hotmail.com (Jeremie) wrote in message > news:<1cb4c644.0403180956.18805158_at_posting.google.com>...
>> When I run this simple sql statement out of VB 6.0 i get the ORA-00937
>> error.
>>
>> select count(*) as SeqNbr from tca_plant_assgn where empID = '14995'
>> and outage_cd = 'C10BO'
>>
Try dropping the 'as' keyword and possibly the entire 'as SeqNbr' and see whether that helps. As it stands, Oracle is seeing a request for multiple columns from VB. You might need to resolve this with a view that does the count(*)
It's not really an Oracle problem as much as a problem with the VB to Oracle interaction.
HTH
/Hans
Received on Tue Mar 30 2004 - 01:03:57 CEST