OraFAQ Forum: Forms » Query regarding a error

Home » Developer & Programmer » Forms » Query regarding a error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query regarding a error [message #217222]

Thu, 01 February 2007 04:12

romi
Messages: 67
Registered: October 2006

Member

Hello all,

I am trying to create an update button that will update a field when pressed I have the plsql code as shown below, the problem i have is,

update pw(table name)

SET password(column name) = :changepw(datablock_name).text4(text_name)
WHERE name(column name) = :changepw(datablock_name).text6(text_name);
COMMIT;
MESSAGE('Record Successfully updated.');
CLEAR_FORM;

error message
identifier 'ADD_NEW_BRANCH' must be declared.

please advise me and also i want to use a link at the place of button.how can i do it.Plz advice me

Thanks.

Report message to a moderator

Re: Query regarding a error [message #217233 is a reply to message #217222]

Thu, 01 February 2007 04:45

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

This code has nothing to do with the error - there's no 'add_new_branch' here. Search through all PL/SQL units to find it and see what it does there (probably should be renamed or removed).

Report message to a moderator

Re: Query regarding a error [message #217235 is a reply to message #217222]

Thu, 01 February 2007 04:51

romi
Messages: 67
Registered: October 2006

Member

Thanks Littlefoot,

It's giving this error, where pw is my table name.

error message
identifier 'pw' must be declared.

Report message to a moderator

Re: Query regarding a error [message #217242 is a reply to message #217235]

Thu, 01 February 2007 05:31

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Don't post pseudocode - show us your exact query. This might give us an idea what might be wrong. Without it, I can only say "declare identifier PW before compiling this program unit".

Report message to a moderator

Previous Topic:	Possible to override Forms commit behaviour?
Next Topic:	Form Query output to Excel ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 14:34:43 CDT 2024