Error 49 Oracle Forms
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business
Bad Bind Variable In Oracle Forms 6i
Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs error 103 in oracle forms Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just
On Error Trigger In Oracle Forms
like you, helping each other. Join them; it only takes a minute: Sign up Error 49 bad bind variable oracle forms up vote 2 down vote favorite I would like to ask regarding this error... Error 49 error 201 in oracle forms at line 5, column 6 bad bind variable 'S_ORD.payment_type' Here is the code: DECLARE N NUMBER; v_credit S_CUSTOMER.credit_rating%type; BEGIN IF :S_ORD.payment_type = 'CREDIT' THEN SELECT credit_rating INTO v_credit FROM S_CUSTOMER WHERE :S_ORD.customer_id = id; IF v_credit NOT IN ('GOOD', 'EXCELLENT') THEN :S_ORD.payment_type:= 'CASH'; n:=SHOW_ALERT('Payment_Type_Alert'); END IF; END IF; END; I'm new to oracle forms so I'm not sure if I have a missing setup or anything. S_ORD table exist and has a column payment_type, which oracle forms error handling consists of 'CREDIT' and 'CASH' value. Thank you. sql forms oracle variables bind share|improve this question asked Jul 5 '12 at 3:39 mysticfalls 12511222 The IF statement references :S_ORD.payment_type, which isn't declared/etc before. It's seen as a BIND variable because of the colon ":". How are you attempting to run this? A script is the only way that makes sense to me ATM. –OMG Ponies Jul 5 '12 at 3:49 @OMG Ponies I'm executing a form named ORDERS...should this be declared or is there anything else I can check that may cause this error..thanks –mysticfalls Jul 5 '12 at 4:07 I don't know Forms, sorry –OMG Ponies Jul 5 '12 at 4:26 add a comment| 4 Answers 4 active oldest votes up vote 0 down vote Oracle Forms doesn't allow the use of bind variables when the code is in a library or a menu. Here is a quote from the Oracle Forms (6i) help: You can reference items indirectly with the NAME_IN and COPY built-in subprograms. The NAME_IN function returns the contents of an indicated variable or item. Use the NAME_IN function to get the value of an item without referring to the item directly. The following statements are equivalent: IF :emp.ename = 'smith' -- direct reference IF NAME_IN('emp.ename') = 'smith' -- indirect reference The
02 January 2008 01:55 sgona Messages: 5Registered: December 2007 Location: pune Junior Member Hi, When i am creating queryfind in myform, I am getting error in creating the fmx.
Oracle Forms Error Messages
Like Compilation error on WHEN-BUTTON-PRESSED trigger on FIND item in QF_BLOCK data block: error 801 oracle forms PL/SQL ERROR 49 at line 7, column 1 bad bind variable 'PARAMETER.G_QUERY_FIND' PL/SQL ERROR 49 at line 7, column
How To Display Error Message In Oracle Forms
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 http://stackoverflow.com/questions/11337582/error-49-bad-bind-variable-oracle-forms the same problem. There is a "REPLY" button in there to continue discussion.] [Updated on: Wed, 02 January 2008 04:25] by ModeratorReport 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: 104Registered: November 2006 Location: India Senior Member hi, Can u pls http://www.orafaq.com/forum/t/94940/ 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: 5Registered: 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 402 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: 20835Registered: June 2005 Location: Croatia, Europe Senior MemberAccount Moderator Does your form contain a block named 'parameter'? Is
onXXXXXXXdata block... Compilation error on KEY-NXTBLK trigger onXXXXXXXdata block: PL/SQL ERROR 49 at line 1, column 1 bad bind variable 'parameter.G_query_find' PL/SQL ERROR http://www.oracleebs.net/2011/07/forms-error-bad-bind-variable.html 49 at line 1, column 1 bad bind variable 'parameter.G_query_find' PL/SQL ERROR 49 at line 3, column 1 bad bind variable 'parameter.G_query_find' Compiling WHEN-NEW-BLOCK-INSTANCE trigger on XXXXXXX data block... Compilation error on WHEN-NEW-BLOCK-INSTANCE trigger onXXXXXXXdata block: PL/SQL ERROR 49 at line 3, column 2 bad bind variable 'parameter.G_query_find' PL/SQL ERROR 49 at line 3, column 2 bad bind oracle forms variable 'parameter.G_query_find' PL/SQL ERROR 49 at line 5, column 2 bad bind variable 'parameter.G_query_find' ....Compilation errors have occurred. Form not created ********************** Cause :FORMS60_PATH not properly set or incorrect Solution: SetFORMS60_PATH=$FORMS60_PATH:$AU_TOP/forms/US:$AU_TOP/resource In your shell simply execute FORMS60_PATH=$FORMS60_PATH:$AU_TOP/forms/US:$AU_TOP/resource This should solve the problem Posted by Ranjith prabu at 4:12:00 PM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest in oracle forms Labels: f60gen, FORMS60_PATH, Oracle applications, parameter.G_query_find 4 comments: NataliaFebruary 17, 2012 at 7:20 AMI do have encountered these errors many times and finally found a solution and the reason behind it through your post. I tried to manipulate so many things to remove this error but everything failed. Thanks for suggesting this nice solution.sap software trainingReplyDeleteRanjith prabuFebruary 17, 2012 at 9:57 PMNatalia. Happy that it helped you..ReplyDeleteBlue_23July 4, 2012 at 1:52 AMHello,I am new to oracle.. I would like to ask what do you mean by this.."In your shell simply executeFORMS60_PATH=$FORMS60_PATH:$AU_TOP/forms/US:$AU_TOP/resource"How is this done?Thank you.ReplyDeleteRepliesRanjith prabuAugust 29, 2012 at 4:00 PMHi Blue, Sorry for the late reply. If you are still facing the problem :I meant type the following in your command line and press enterFORMS60_PATH=$FORMS60_PATH:$AU_TOP/forms/US:$AU_TOP/resourceDeleteReplyAdd commentLoad more... Newer Post Home Subscribe to: Post Comments (Atom) LinkWithin About Me Ranjith prabu View my complete profile Search This Blog Loading... Total Pageviews Popular Posts R12 - SQL Query to get payment method for a vendor site Unlike in 11i, the payment meth