Error 49 Oracle
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the
Bad Bind Variable In Oracle
workings and policies of this site About Us Learn more about Stack pls 00049 bad bind variable Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Bad bind variable error in Oracle 10g developer form up vote -1 down vote favorite I have created a table named password CREATE TABLE PASSWORD (USER_ID NUMBER(10) CONSTRAINT PASSWORD_USER_ID_PK PRIMARY KEY, PASSWD VARCHAR2(20) NOT NULL); INSERT INTO PASSWD (USER_ID,PASSWD) VALUES (1,100); INSERT INTO PASSWD (USER_ID,PASSWD) VALUES (2,200); And created a Login form in an Oracle form developer 10g. And I used this code into Login button. DECLARE CURSOR login_cursor IS SELECT user_id, passwd FROM password; user_id_var password.user_id%TYPE; passwd_var password.passwd%TYPE; login_flag BOOLEAN := FALSE; BEGIN OPEN login_cursor; <
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 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 http://stackoverflow.com/questions/15834905/bad-bind-variable-error-in-oracle-10g-developer-form 'parameter.G_query_find' PL/SQL ERROR 49 at line 3, column 2 bad bind 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 http://www.oracleebs.net/2011/07/forms-error-bad-bind-variable.html Posted by Ranjith prabu at 4:12:00 PM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest 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 Ra
the error, the probable cause, and the recommended action. Each error code corresponds to an exception class. See "Runtime and Development Exceptions" for more information. Format: A description shown in the actual exception thrown. Cause: The most probable cause https://docs.oracle.com/cd/A97688_16/toplink.903/b10068/errorcod.htm for the error. Action: Suggestions for resolving the error. Descriptor Exceptions (1 - https://community.oracle.com/thread/3957810 176) Error code: 1 ATTRIBUTE_AND_MAPPING_WITH_INDIRECTION_ MISMATCH Cause:
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in DBA Plus Community-DBAplus All PlacesDBA Plus Community-DBAplus 0 Replies Latest reply on Aug 3, 2016 4:21 AM by 3068916 While apply patch(8294645) getting error 3068916 Aug 3, 2016 4:21 AM Hi,we are getting error while searching order number in Transaction form.Please find the attached file.and while apply patch getting below error." No compilation errors.Compiling package specification FLEXFIELDS... No compilation errors.Compiling package body FLEXFIELDS... No compilation errors.Compiling package specification GRANTS... No compilation errors.Compiling package body GRANTS... No compilation errors.Compiling package specification LAYOUT... No compilation errors.Compiling package body LAYOUT... No compilation errors.Compiling package specification MESSAGES... No compilation errors.Compiling package body MESSAGES... No compilation errors.Compiling package specification NAVIGATION... No compilation errors.Compiling package body NAVIGATION... No compilation errors.Compiling package specification SHIPPING_INTEGRATIONS... No compilation errors.Compiling package body SHIPPING_INTEGRATIONS... No compilation errors.Compiling package specification TRIP... No compilation errors.Compiling package body TRIP... No compilation errors.Compiling package specification ACCESSIBILITY_CUSTOM... No compilation errors.Compiling package body ACCESSIBILITY_CUSTOM... No compilation errors.Compiling package specification ACTIONS_AUX_CUSTOM... No compilation errors.Compiling package body ACTIONS_AUX_CUSTOM... No compilation errors.Compiling package specification ACTIONS_CUSTOM... No compilation errors.Compiling package specification COMMON_CUSTOM... No compilation errors.Compiling package body COMMON_CUSTOM... No compilation errors.Compiling package specification DATA_PROTECTION_CUSTOM... No compilation errors.Compiling package body DATA_PROTECTION_CUSTOM... No compilation errors.Compiling package specification EXCEPTIONS_CUSTOM... No compilation errors.Compiling package body EXCEPTIONS_CUSTOM... No compilation errors.Compiling package specification GRANTS_CUSTOM... No compilation errors.Compiling package body GRANTS_CUST