ORA-600 Using Dev2000

From: Dean Mah <dmah_at_acs.ucalgary.ca>
Date: Tue, 12 May 1998 12:03:35 -0600
Message-ID: <6ja2ug$86e_at_ds2.acs.ucalgary.ca>

[Quoted] [Quoted] I'm trying to write a Developer 2000 application that will change the password of any user. I have tried using the following code:

   query := 'ALTER USER ' || :username || ' IDENTIFIED BY test';    cid := DBMS_SQL.OPEN_CURSOR;
   DBMS_SQL.PARSE(cid, query, 2);
   status := DBMS_SQL.EXECUTE(cid);
   DBMS_SQL.CLOSE_CURSOR(cid);

This works if I type it into SQL*Plus but does not work from Developer 2000 when it is attached as a trigger to a button. When I press the button, it throws an ORA-600 error with a single argument, 15450.

Anybody have any experience with this?

Dean Received on Tue May 12 1998 - 20:03:35 CEST