Home » RDBMS Server » Server Administration » frm error
frm error [message #54547] Thu, 21 November 2002 03:42 Go to next message
ssa
Messages: 8
Registered: November 2002
Junior Member
i have developed a form which is usefull to change the user password, and the users details also stored in a table called users, so in the block(usr) i am using this table. and written a trigger called WHEN-BUTTON-PRESSED
DECLARE
A NUMBER;
BEGIN
A:=DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(A,'ALTER USER usr.id identified by usr.newpass',1);
DBMS_SQL.CLOSE_CURSOR(A);
END;

when the button pressed it giving error,
"FRM-40735:WHEN BUTTON PRESSED trigger raised unhandled exception ORA-00922"

please any body can help it is vrey urgent, i will be greate full to u.

with best regards

Report message to a moderator

Re: frm error [message #54550 is a reply to message #54547] Thu, 21 November 2002 05:25 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
I assume 'usr' is either a block or a record set.

Try concatenating, because you're parsing the string as a whole.
DBMS_SQL.PARSE(A,'ALTER USER '||usr.id||' identified by '||usr.newpass,1);

Why don't you use native dynamic SQL?

MHE

Report message to a moderator

Re: frm error [message #54626 is a reply to message #54550] Sun, 24 November 2002 01:52 Go to previous message
ssa
Messages: 8
Registered: November 2002
Junior Member
Thank q for help, but it is not working and itis giving error when trigger is complied.

can u explain what is native dynamic sql, and how it is work.

hope u feel free to exaplain.

thank q

Report message to a moderator

Previous Topic: Urgent! Import - basic question
Next Topic: Changing a Standby Controlfile
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 18:07:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.