OraFAQ Forum: Forms » Bad bind variable error

Home » Developer & Programmer » Forms » Bad bind variable error

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

Bad bind variable error [message #290907]

Wed, 02 January 2008 01:55

sgona
Messages: 5
Registered: December 2007
Location: pune

Junior Member

Hi,
When i am creating queryfind in myform, I am getting error in creating the fmx. Like

Compilation error on WHEN-BUTTON-PRESSED trigger on FIND item in QF_BLOCK data block:
PL/SQL ERROR 49 at line 7, column 1
bad bind variable 'PARAMETER.G_QUERY_FIND'
PL/SQL ERROR 49 at line 7, column 1
bad bind variable 'PARAMETER.G_QUERY_FIND'
PL/SQL ERROR 49 at line 9, column 1
bad bind variable 'PARAMETER.G_QUERY_FIND'

Plzzz help me.

[MERGED by LF: please, do not open a new topic about the same problem. There is a "REPLY" button in there to continue discussion.]

[Updated on: Wed, 02 January 2008 04:25] by Moderator

Report message to a moderator

Re: bad bind variable error when creating queryfind. [message #290932 is a reply to message #290907]

Wed, 02 January 2008 04:00

mintomohan
Messages: 104
Registered: November 2006
Location: India

Senior Member

hi,

Can u pls attach the fmb

Minto

Report message to a moderator

bad bind variable error when creating queryfind. [message #290939 is a reply to message #290907]

Wed, 02 January 2008 04:13

sgona
Messages: 5
Registered: December 2007
Location: pune

Junior Member

Hi,

Thans for u r reply.I am attaching fmb here.

When i am creating queryfind in myform, I am getting error in creating the fmx. Like
Compilation error on WHEN-BUTTON-PRESSED trigger on FIND item in QF_BLOCK data block:
PL/SQL ERROR 49 at line 7, column 1
bad bind variable 'PARAMETER.G_QUERY_FIND'
PL/SQL ERROR 49 at line 7, column 1
bad bind variable 'PARAMETER.G_QUERY_FIND'
PL/SQL ERROR 49 at line 9, column 1
bad bind variable 'PARAMETER.G_QUERY_FIND'

It is compling successfully. But when i am generating fmx it is giving error.

Plzzz help me.

Attachment: APINVOICEFORM1.fmb
(Size: 556.00KB, Downloaded 1425 times)

Report message to a moderator

Re: bad bind variable error when creating queryfind. [message #290943 is a reply to message #290907]

Wed, 02 January 2008 04:22

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

Senior Member
Account Moderator

Does your form contain a block named 'parameter'? Is there an item called 'g_query_find'?

Report message to a moderator

Re: bad bind variable error when creating queryfind. [message #290946 is a reply to message #290939]

Wed, 02 January 2008 04:27

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

(Or)
Do you think you forgot to define a parameter named G_QUERY_FIND in the Parameters section?

By
Vamsi

Report message to a moderator

Re: bad bind variable error when creating queryfind. [message #290947 is a reply to message #290943]

Wed, 02 January 2008 04:31

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

Senior Member
Account Moderator

Right; he "forgot" to create a parameter.

Report message to a moderator

Re: bad bind variable error when creating queryfind. [message #291015 is a reply to message #290947]

Wed, 02 January 2008 12:53

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

Senior Member
Account Moderator

Received via private messaging system:

sgona

Thangs for u r response. This is swathi(sgona). But i created parameter G_QUERY_FIND . I attached my fmb Pls check it once.

I'm sorry, but I don't see it. There's only 'folder_operation_mode' parameter.

/forum/fa/3685/0/

Attachment: apinvoice.PNG
(Size: 4.18KB, Downloaded 10664 times)

Report message to a moderator

Re: bad bind variable error when creating queryfind. [message #291329 is a reply to message #290939]

Thu, 03 January 2008 22:41

mintomohan
Messages: 104
Registered: November 2006
Location: India

Senior Member

hi,

QF_BLOCK.FIND is a text item, and you have added a WHEN-BUTTON-PRESSED trigger on that !!!???

Minto

Report message to a moderator

Re: bad bind variable error when creating queryfind. [message #291383 is a reply to message #291329]

Fri, 04 January 2008 01:14

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Good eyes..... /forum/fa/1693/0/

By
Vamsi

Report message to a moderator

Re: bad bind variable error when creating queryfind. [message #291417 is a reply to message #291383]

Fri, 04 January 2008 02:42

mintomohan
Messages: 104
Registered: November 2006
Location: India

Senior Member

thanks Vamsi Smile

i don't think the code in that trigger would ever get executed!

Minto

Report message to a moderator

Re: bad bind variable error when creating queryfind. [message #300326 is a reply to message #290939]

Fri, 15 February 2008 01:20

alayam
Messages: 8
Registered: November 2006
Location: Hyderabad

Junior Member

Set the Form60gen path.

For example in UNIX..

your at custom_top.. in which top you want to generate the fmx ..

Find out the autop path like below example. then run this path in the customtop path.

export FORMS60_PATH=$FORMS60_PATH:/u01/app/appprmc/srceptchappl/au/11.5.0/forms/US

Report message to a moderator

Previous Topic:	Function that Return Previous Month of current date
Next Topic:	getting error while accessing d2k form builder

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 10:36:06 CST 2025