Additional
dbCAP
AnyDAC
ThinDAC
NCOCI8
Topic: changing the password
changing the password
Posted: 2002/06/11 02:45
 
Hi,
I m trying to change my password through an Edit and an OCIQuery :
alter user :LOGIN identified by ASSWORD

params are transmitted like this :
OCIQuery1.ParamByName('PASSWORD').AsString := Edit3.Text;

But, while the request becomes active, an error message appears :
ORA-01036: number/name of variable illegal

It isn t a pb of rules (i try to modify my own password) so where does it come from ?
RE: changing the password
Posted: 2002/06/12 00:04
 
next episode :
i tried to change my password without passing any parameters :
alter user scott identified by tiger

after execution, a new error appears :
OCIQuery1:NOE127/DS Can not call Open for a statement withour rowset
What does it mean and how can i resolve this problem (this error appears also when activating a select query) ?

thanks
RE: changing the password
Posted: 2002/06/13 22:18
 
Use no parameters and ExecSQL method