OraFAQ Forum: Forms » ERROR: Bad Binding Variable

Home » Developer & Programmer » Forms » ERROR: Bad Binding Variable (Oracle Forms 10g on Windows XP)

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

ERROR: Bad Binding Variable [message #345755]

Thu, 04 September 2008 13:30

davydany
Messages: 11
Registered: September 2008
Location: New Hyde Park

Junior Member

I'm using Oracle Forms 10g on Windows XP.

I'm trying to create a login form and send the user's ID and their role on the system via a parameter from the login form to the main form. I got this part done by looking at this topic(http://www.orafaq.com/forum/m/309502/0/?srch=text+item%27s+value#msg_309502)

The problem I'm having is that I'm getting "BAD BINDING VARIABLE". In the topic I got the login form from, Kaeluan used this: 'userid='''||parameters.p_userid||'' ', and I don't get the syntax for that. So I looked at how to reference parameters, and the help in Oracle Forms gave this:

:block.item := :PARAMETER.parameter_name;

When I do that, I get "BAD BINDING VARIABLE"

Any Ideas? And if that is a bad idea, could anyone tell me how to properly accept parameters from another form in 10g?

I also attached my setup.

Thanks!

Attachment: parameters_problem.JPG
(Size: 155.05KB, Downloaded 499 times)

Report message to a moderator

Re: ERROR: Bad Binding Variable [message #345817 is a reply to message #345755]

Thu, 04 September 2008 22:41

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

In Forms Builder, Object Navigator window, under the heading 'Parameters' create 'usr_role'.

David

Report message to a moderator

Re: ERROR: Bad Binding Variable [message #345828 is a reply to message #345817]

Thu, 04 September 2008 23:56

sasipalarivattom
Messages: 121
Registered: June 2007
Location: Cochin ( INDIA )

Senior Member

Hi dear,
One more thing,

Change your block name to "BLOCKS" or change the code like

:BLOCK5.USR_ROLE:=:PARAMETER.USR_ROLE;

Don't forgot to create the parameter, as Mr. David said.

Regards,
Sasi...

Report message to a moderator

Re: ERROR: Bad Binding Variable [message #345985 is a reply to message #345755]

Fri, 05 September 2008 08:14

davydany
Messages: 11
Registered: September 2008
Location: New Hyde Park

Junior Member

Thanks guys. I did both the things you said, and that did the trick. Thanks!

Report message to a moderator

Previous Topic:	help.adding values to LOV at runtime.
Next Topic:	POPUP Confirmation in oracle Form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 01:19:35 CST 2024