Oracle Forms Pl/sql Error 201
Contents |
must be declare [message #584526] Wed, 15 May 2013 01:08 sameer_da Messages: 74Registered:
Identifier Must Be Declared
April 2013 Location: India Member [MERGED by LF] Hii, sql 2016 I am importing excel data to oracle table by column mapping using forms 6i.
Sql 2014
I am using ole2 package and i also created one package.which is given below. My code gets compiled, I am unable to insert record to the table.Values are passed to the procedure, i am able to see the values while debugging, but all values are seen in record 1 (as looping is there) all other remaining records are empty.i.e records are changing but seen only in record 1 and all other records are empty.I also get message 'DATA INSERTED INTO THE TABLE' but when i check it with sql, the table is empty. PROCEDURE get_excel IS APPLICATION OLE2.OBJ_TYPE; WORKBOOKS OLE2.OBJ_TYPE; WORKBOOK OLE2.OBJ_TYPE; WORKSHEETS OLE2.OBJ_TYPE; WORKSHEET OLE2.OBJ_TYPE; CELL OLE2.OBJ_TYPE; CTR NUMBER(12); COLS NUMBER(2); CELLVALUE VARCHAR2(89); C_ROUTE VARCHAR2(255); V_ROUTE VARCHAR2(1000); C_TRNDATE VARCHAR2(255); V_TRNDATE VARCHAR2(1000); FILENAME VARCHAR2(500); v_path varchar2(1000):=:path; ARGS OLE2.OBJ_TYPE; l_sql varchar2(32767); i_ldata PK_EXCEL_TO_DB.tDataList:=PK_EXCEL_TO_DB.tDataList(); tDataList PK_EXCEL_TO_DB.tDataList; rowcounter number; BEGIN :progress:='Please wait...'; SYNCHRONIZE; --------------INITIATE EXCEL APPLICATION--------------------------- filename := V_PATH;--GET_FILE_NAME('c:\', File_Filter=>'Excel Files (*.xls)|*.xls|'); -- to pick the file APPLICATION := OLE2.CREATE_OBJ('EXCEL.APPLICATION'); OLE2.SET_PROPERTY(APPLICATION,'VISIBLE','FALSE'); ----------------GET WORKBOOKS FROM EXCEL APPLICATION--------------- WORKBOOKS := OLE2.GET_OBJ_PROPERTY(APPLICATION, 'WORKBOOKS'); ----------------OPEN REQUIRED WORKBOOK----------------------------- ARGS := OLE2.CREATE_ARGLIST; OLE2.ADD_ARG(ARGS, FILENAME); WORKBOOK := OLE2.GET_OBJ_PROPERTY(WORKBOOKS,'OPEN',ARGS); OLE2.DESTROY_ARGLIST(ARGS); ----------------OPEN REQUIRED WORKSHEET--------------------------- ARGS := OLE2.CREATE_ARGLIST; OLE2.ADD_ARG(ARGS,'Sheet1'); WORKSHEET := OLE2.GET_OBJ_PROPERTY (WORKBOOK,'WORKSHEETS',ARGS); OLE2.DESTROY_ARGLIST(ARGS); ----------------GET CELL VALUE------------------------------------- ctr := 2; --row number cols := 1; -- column number FIRST_RECORD; LOOP i_ldata.extend(1); rowcounter:= i_ldata
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 General EBS Discussion All PlacesOracle ApplicationsE-Business SuiteE-Business Suite TechnologyGeneral EBS Discussion 1 Reply Latest reply on Jul 7, 2016 12:52 PM by Bashar. Form Compilation error SoundariyaKumar Jul 6, 2016 5:35 AM Hi, we have a custom form which is created http://www.orafaq.com/forum/t/187798/ long back and it is working fine all these days.now when we try to compile it in server using the following command,frmcmp_batch userid=
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full https://www.experts-exchange.com/questions/21390492/oracle-form-error.html Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > oracle form error http://www.dbforums.com/showthread.php?993967-forms-saving-will-lose-libraires-module-11iapps Want to Advertise Here? Solved oracle form error Posted on 2005-04-15 Oracle Database 1 Verified Solution 10 Comments 4,569 Views Last Modified: 2012-08-13 hi, a really big problem happen to my form, its oracle forms working fine untill when i try to re-run back the form i recieve the error as below Compiling ON-POPULATE-DETAILS trigger on OFFERING data block... Compilation error on ON-POPULATE-DETAILS trigger on OFFERING data block: PL/SQL ERROR 201 at line 23, column 5 identifier 'QUERY_MASTER_DETAILS' must be declared PL/SQL ERROR 0 at line 23, column 5 Statement ignored PL/SQL ERROR 201 at line 31, column 6 identifier 'CHECK_PACKAGE_FAILURE' oracle forms pl/sql must be declared PL/SQL ERROR 0 at line 31, column 6 Statement ignored Compiling ON-POPULATE-DETAILS trigger on COURSE data block... Compilation error on ON-POPULATE-DETAILS trigger on COURSE data block: PL/SQL ERROR 201 at line 23, column 5 identifier 'QUERY_MASTER_DETAILS' must be declared PL/SQL ERROR 0 at line 23, column 5 Statement ignored PL/SQL ERROR 201 at line 31, column 6 identifier 'CHECK_PACKAGE_FAILURE' must be declared PL/SQL ERROR 0 at line 31, column 6 Statement ignored Compilation errors have occurred. ---------------------------- below is my offering datablock detail -- Begin default relation program section -- BEGIN IF ( recstat = 'NEW' or recstat = 'INSERT' ) THEN RETURN; END IF; -- -- Begin ATTENDANCE detail program section -- IF ( (:OFFERING.OFFERING_ID is not null) ) THEN rel_id := Find_Relation('OFFERING.OFFERING_ATTENDANCE'); Query_Master_Details(rel_id, 'ATTENDANCE'); END IF; -- -- End ATTENDANCE detail program section -- IF ( :System.cursor_item <> startitm ) THEN Go_Item(startitm); Check_Package_Failure; END IF; END; -- -- End default relation program section -- ----------------------------------------------- and below is course datablock ----
your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 2 of 2 Thread: forms ---saving will lose libraires module-11iapps Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 04-15-04,09:43 #1 etravels View Profile View Forum Posts Registered User Join Date Feb 2004 Posts 93 Unanswered: forms ---saving will lose libraires module-11iapps hiya I am using Oracle Form --ASTRCALL.fmb as part of the Oracle 11iApps and if I make changes in the forms designer (in the property palette), if I then save the form, it will not have all the plsql libaries attached: I see this when I ftp the file over to UNIX box, (going into $AU_TOP/forms/US/ASTRCALL.fmb THEN COMPILE FORM; f60gen module= ASTRCALL.fmb apps/apps output_file = =$AST_TOP/forms/US/ASTRCALL.fmx module_type=form compile_all=special I get errors: form is not created along with all the plsql libaries not attached. While compiling ##### Compiling ASTRCALL Forms 6.0 (Form Compiler) Version 6.0.8.14.2 (Production) Forms 6.0 (Form Compiler): Release - Production (c) Copyright 1999 Oracle Corporation. All rights reserved. Oracle8i Enterprise Edition Release 8.1.7.1.0 - Production With the Partitioning option JServer Release 8.1.7.1.0 - Production PL/SQL Version 8.0.6.3.0 (Production) Oracle Procedure Builder V6.0.8.14.0 Build #0 - Production Oracle Virtual Graphics System Version 6.0.5.37.0 (Production) Oracle Multimedia Version 6.0.5.33.0 (Production) Oracle Tools Integration Version 6.0.8.13.0 (Production) Oracle Tools Common Area Version 6.0.5.32.0 Oracle CORE Version 4.0.6.0.0 - Production Compiling package specification APP_CUSTOM... No compilation errors. Compiling package specification IEU_MEDIAEVENT_INT... No compilation errors. Compiling package specification NONOTS_INTEGRATION