Fatal Pl/sql Error Occurred
Contents |
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 rep-1401 '' fatal pl/sql error occurred. rep-0069 internal error on and reload this page. Please enter a title. You rep-1401 a fatal pl/sql error occurred in program unit can not post a blank message. Please type your message and try again. More discussions in rep-1401 error in oracle reports Reports All PlacesDevelopment ToolsReports This discussion is archived 5 Replies Latest reply on Apr 16, 2014 1:29 PM by O.Developer rep 1401 fatal pl sql error occurred
Rep-1401 'beforereport' Fatal Pl/sql Error Occurred
ora 06502 PL/SQL:numeric or value error 1010331 Mar 24, 2014 2:04 PM Hi,I am getting an error while runnig the following formula column.function open_balFormula return Number is open_bal number(11,2) open_db number(11,2) open_cr number(11,2)begin select SUM(NVL(DEB_AMT,0),SUM(NVL(CRE_AMT,0)) into OPEN_DB,OPEN_CR FROM GL_TRIAL_BAL where TRANS_date < :start_date and gl_acct#= :from_acct;open_bal := nvl(open_db,0) - nvl(open_cr,0);return(0);exception when no_data_foundthen return(0);end;It rep-1401 'afterpform' fatal pl/sql error occurred is working fine i will give starting date 01/01/2013 and end date 31/12/2013.but if i give starting date 01/01/2014 and end date 31/12/2014 It is showing following error.rep 1401 fatal pl sql error occurred ora 06502 PL/SQL:numeric or value error Thank youHelp will be appreciable. I have the same question Show 0 Likes(0) 6408Views Tags: none (add) 9iContent tagged with 9i, databaseContent tagged with database, oracleContent tagged with oracle, reportContent tagged with report, 3.0Content tagged with 3.0 This content has been marked as final. Show 5 replies 1. Re: rep 1401 fatal pl sql error occurred ora 06502 PL/SQL:numeric or value error Siva-Oracle Mar 26, 2014 3:29 AM (in response to 1010331) Please try executing this function in sqlplus with start date as 01/01/2014 and check whether it is working. Like Show 0 Likes(0) Actions 2. Re: rep 1401 fatal pl sql error occurred ora 06502 PL/SQL:numeric or value error Soofi Apr 2, 2014 4:23 AM (in response
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 Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers rep-1401 cf_1 formula Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > REP-1401: PL/SQL Fatal error occurred
Rep-1401 'afterreport' Fatal Pl/sql Error Occurred
Want to Advertise Here? Solved REP-1401: PL/SQL Fatal error occurred Posted on 2005-02-07 Oracle Database 1 Verified Solution 6 Comments 23,047 Views Last Modified: 2013-12-12
Rep 1401 Fatal Pl Sql Error Occurred Rep 57054
I work with PL/SQL 5, and DEVELOPER 6.0. The database is ORACLE 8.1.6 I replaced all references to a particular table for a PL/SQL table defined in a package in the next manner: type typ_reg_selex is record (clvexp char(19), ctipo https://community.oracle.com/thread/3537979 number(1)); type typ_cur_selex is ref cursor return typ_reg_selex; type typ_tab_selex is table of typ_reg_selex; I define in the package a table of type typ_tab_selex, thus the table is in memory and I can access it both from FORMS and from database procedures. It is in a production system and works perfectly. The problem is in REPORTS. I need to create a query about this memory table. I do it with I ref cursor query. The sintax https://www.experts-exchange.com/questions/21304448/REP-1401-PL-SQL-Fatal-error-occurred.html is: Select * from table(my_table) It´s compile well, but when running occurs REP-1401 error: PL/SQL fatal error. I probe anything similar in FORMS and also it compile well, but when running it, it freezes. I have two questions?? 1. Why occurs this, is it a bug problem?? 2. Someone can give me another solution to generate a report from a table of this type (memory table). thanks in advance. 0 Question by:core007 Facebook Twitter LinkedIn Google LVL 11 Best Solution bysujit_kumar REP-1401 occurs when trying to DIVIDE by ZERO (0). So use ZERO_DIVIDE exception handler As shown in the example below. declare n number; begin select 5/0 into n from dual; end; ORA-01476: divisor Go to Solution 4 Comments LVL 4 Overall: Level 4 Oracle Database 3 Message Expert Comment by:alexnuijten2005-02-07 You can't do: Select * from table(my_table) when my_table is a PL/SQL table, you can if it's a SQL defined Table type. What you can do is create a User Defined Nested Table Type directly in SQL, as in: Create type Table_type as table of varchar2(150) This you can access as a regular database table. If you want to create a table type based on a record, you need to create an Object in SQL. SQL> create type record_like_ot as object 2 (id number 3 ,value varchar2(100) 4 ) 5 / Type created. SQL> create type table_type as table of record_like_ot 2 / Type created. Alex (I don't have ac
a report you encounter the below errors:- REP-1401: '': Fatal PL/SQL http://arunreddyd.blogspot.com/2014/04/oracle-report-error-rep-1401-fatal.html error occurred. REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error: The most common reason for the above error is:- No return value in https://groups.google.com/d/topic/comp.databases.oracle.tools/4BZ4L3tUmCk one of your functions defined in the report definition. Solution:- Ensure that all the functions defined in the report definition has a return error occurred value. Also ensure that there is return value outside the 'if condition' statements Posted by Arun Reddy at 10:19 PM Labels: Oracle EBS - Technical No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Pages Oracle Fusion Applications and E-Business Suite About sql error occurred Arun Reddy D Hi !!,This is Arun Reddy , Oracle E-Business Suite and Fusion Middlware Techno Functional Consultant.I have 8+ years of experience in the Oracle Industry.I have good knowledge and experience on the below technologies:-Oracle E-Business SuiteVersions: 11.0.3 to R12.xModules:--General Ledger-Account Payables-Account Receivables-Fixed Assets-Cash Management-Purchasing-Inventory-Projects Costing-Projects Billing-iAssets-iProcurement-iReceivables-iExpensesTechnical Skills:--OAF Technology-BI or XML Publisher-Oracle Forms and Reports (6i to 11g)-Oracle Discoverer-ADI and Web ADI-SQL-PLSQL-Java (Core and Advanced)-XMLFusion Middleware-Oracle ADF (Application Development Framework) 10g to 11g-SOA (Service Oriented Architecture) 11g-Webservices-Weblogic ServerCurrently I am living and working in Perth, WA, Australia.You can contact me on arunapps@gmail.comRegards,Arun Reddy. Labels Oracle EBS - CE (1) Oracle EBS - Technical (1) Oracle EBS-AP (1) Oracle EBS-General (1) Oracle EBS-GL (1) Oracle EBS-PA (6) Oracle EBS-PO (4) Blog Archive Blog Archive April (4) March (1) February (8) November (1) October (1) About Me Arun Reddy Certified Oracle E-Business Su
från GoogleLogga inDolda fältSök efter grupper eller meddelanden