Re: [Gusdev-gusdev] deleteEntries.pl error

[Deborah F. P. <pi...@pc...>]

Hi,

The sql query should have been --idSQL 'delete from DoTS.NRDBEntry 
where nrdb_entry_id=1' rather than ...DoTS::NRDBEntry...

                                                     Debbie
                                                     

On Wed, 10 Dec 2003, sucheta Tripathy wrote:

> 
> Hi,
> 
> I have been trying to use the deleteEntries.pl program to delete some of
> the rows inserted into the DoTS::NRDBEntry table.
> 
> First it gave an insufficient privilege error, so when we looked at the
> code at line 30, 31, we noticed, it calls the
> $gusconfig->getReadOnlyDatabaseLogin(),
> $gusconfig->getReadOnlyDatabasePassword()
> 
> which has only readonly privileges (From the .gus.properties file).
> 
> So I changed it to
> 
> $gusconfig->getDatabaseLogin(),
> $gusconfig->getDatabasePassword(), at those 2 lines which has read, write,
> delete privileges.
> 
> The options I have used are:
> 
> deleteEntries.pl --idSQL 'delete from DoTS::NRDBEntry where
> nrdb_entry_id=1' --table DoTS::NRDBEntry
> 
> It is throwing the following errors:
> 
> Reading properties from /home/apps/gus/.gus.properties
> The login is GUSrw
> DBD::Oracle::st execute failed: ORA-00933: SQL command not properly ended
> (DBD E
> RROR: OCIStmtExecute) [for Statement "delete from DoTS::NRDBEntry where
> nrdb_ent
> ry_id=3" with ParamValues: :NRDBEntry=undef] at
> /home/apps/gus/gushome/lib/perl/
> GUS/ObjRelP/DbiDbHandle.pm line 82.
> Execute FAILED: ORA-00933: SQL command not properly ended (DBD ERROR:
> OCIStmtExe
> cute)
>  sql_cmd:
>  delete from DoTS::NRDBEntry where nrdb_entry_id=3
> DBD::Oracle::st fetchrow_array failed: ERROR no statement executing
> (perhaps you
>  need to call execute first) [for Statement "delete from DoTS::NRDBEntry
> where n
> rdb_entry_id=3" with ParamValues: :NRDBEntry=undef] at
> /home/apps/gus/gushome/bi
> n/deleteEntries.pl line 51.
> deleting 0 ids from DoTS::NRDBEntry
>