Home » Developer & Programmer » Forms » ERROR: Bad Binding Variable (Oracle Forms 10g on Windows XP)
ERROR: Bad Binding Variable [message #345755] Thu, 04 September 2008 13:30 Go to next message
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!
Re: ERROR: Bad Binding Variable [message #345817 is a reply to message #345755] Thu, 04 September 2008 22:41 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
In Forms Builder, Object Navigator window, under the heading 'Parameters' create 'usr_role'.

David
Re: ERROR: Bad Binding Variable [message #345828 is a reply to message #345817] Thu, 04 September 2008 23:56 Go to previous messageGo to next message
sasipalarivattom
Messages: 118
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...
Re: ERROR: Bad Binding Variable [message #345985 is a reply to message #345755] Fri, 05 September 2008 08:14 Go to previous message
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!
Previous Topic: help.adding values to LOV at runtime.
Next Topic: POPUP Confirmation in oracle Form
Goto Forum:
  


Current Time: Sun Dec 11 08:19:32 CST 2016

Total time taken to generate the page: 0.07975 seconds