Re: ORA-600 Using Dev2000

Dean,

[Quoted] It is a problem with your RDMBS, not developer/2000. Probably you're using forms 4.5 which uses special method to access RDBMS stored PL/SQL. From SQL*Plus it may work fine.

Call your support. If you have no maintenance nor support try recreating packages PISTUB, PIDIAN, PIPIDL.

HTH,
Piotr Kolodziej

Dean Mah wrote in message <6ja2ug$86e_at_ds2.acs.ucalgary.ca>...
>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?
Received on Tue May 12 1998 - 21:18:35 CEST