Oracle Internal Error 1401
Contents |
internal error [1401] on Oracle 11 Pages 1 You must login or register to post a reply Topic RSS feed Posts [ 5 ] 1 Topic by if_else 2012-05-03 03:46:23 pls-00801: internal error [phdcsql_print_kge_errors::parm pos] if_else New member Offline Registered: 2012-05-03 Posts: 3 Topic: PLS-00801: internal error [1401] ora-06544 pl/sql internal error arguments on Oracle 11 Hello. I ask advise what conditions the given error can to be provoked? 2 Reply by swapoff pls-00801: internal error [hshuid:lu invalid] 2012-05-03 04:38:24 swapoff Member Offline Registered: 2012-05-02 Posts: 56 Re: PLS-00801: internal error [1401] on Oracle 11 $ORACLE_HOME/rdbms/admin/utlirp.sql$ORACLE_HOME/rdbms/admin/utlrp.sqlFulfill these scripts from sys 3 Reply by if_else 2012-05-03 05:28:24 if_else New member Offline Registered: pls 00801 internal error phdite node kind 2012-05-03 Posts: 3 Re: PLS-00801: internal error [1401] on Oracle 11 swapoff;It helps, but why the error appears again appears remains not clear. The Oracle 11 can does not get on with the parameters declared in function by default? 4 Reply by swapoff 2012-05-03 07:11:24 swapoff Member Offline Registered: 2012-05-02 Posts: 56 Re: PLS-00801: internal error [1401] on Oracle 11 On a metalink this consequence of
Pls-00801: Internal Error [ph2csql_strdef_to_diana:bind]
an upgrade or an overlay 11 is written thatCauseThis issue is caused by inconsistencies in underlying application codelines and binariesas a result of recent patching and (potential) database updgrades.And type should will be corrected by recompilation.Try in procedure that that simply to correct (well type a line of comments to add) and . 5 Reply by if_else 2012-05-03 08:23:25 if_else New member Offline Registered: 2012-05-03 Posts: 3 Re: PLS-00801: internal error [1401] on Oracle 11 Compilation of it does not transit, compilation of the connected eliminates an error Posts [ 5 ] Pages 1 You must login or register to post a reply Programmer's Town »Databases »PLS-00801: internal error [1401] on Oracle 11 Jump to forum: .NET .NET GUI ASP.NET ATL/WTL C/C++ C/C++ Applied COM/DCOM/ActiveX Delphi & Builder Java MFC Qt Unix Visual Basic WIN API XML / SOAP Declarative programming Dynamic languages Tools Databases Web Programming Hardware Installation, administration, support Multimedia, graphics, sound Mobile Devices Low-level programming Game Development Network sockets, protocols Miscellaneous Software Algorithms Software Architecture User Interface: design, usability Project Management Application Testing Programming philosophy Etudes for Programmers Education and science About Life Shareware and business Computers Holy Wars - Other Random topics
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 8 of 8 Thread: PL/SQL compilation error 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 02-12-09,06:07 #1 sathidevi View Profile View Forum Posts Registered User Join Date May 2006 Posts 46 Unanswered: PL/SQL compilation error Hi Experts, While compiling one of my stored procedures, I am getting this peculiar error. PLS-00801: internal error http://www.progtown.com/topic522981-pls00801-internal-error-1401-on-oracle-11.html [phdcsql_print_kge_errors:arm pos] Please help me to fix this. Thanks PS Reply With Quote 02-12-09,07:00 #2 Littlefoot View Profile View Forum Posts Lost Boy Join Date Jan 2004 Location Croatia, Europe Posts 4,090 Provided Answers: 4 Without a procedure code, here you are: Originally Posted by Oracle PLS-00801: internal error [string] Cause: This is a generic internal error that might occur during compilation or execution. The first parameter is the internal error number. Action: Report this error as http://www.dbforums.com/showthread.php?1638229-PL-SQL-compilation-error a bug to your Customer Support representative. Reply With Quote 02-12-09,10:17 #3 anacedent View Profile View Forum Posts Registered User Join Date Aug 2003 Location Where the Surf Meets the Turf @Del Mar, CA Posts 7,776 Provided Answers: 1 Can you debug code you can not see? (I doubt it because it appears you can not debug code you can see.) Most folks can't. You can lead some folks to knowledge, but you can not make them think. The average person thinks he's above average! For most folks, they don't know, what they don't know. Good judgement comes from experience. Experience comes from bad judgement. Reply With Quote 02-12-09,23:12 #4 sathidevi View Profile View Forum Posts Registered User Join Date May 2006 Posts 46 I don't see any error in the code as such. I walked thru' the code of 1000 lines, but no error. Even if there is any error, that would be the compilation errors where we can fix it. But this is totally an irrelevant error. Please help. Thanks PS Reply With Quote 02-12-09,23:33 #5 anacedent View Profile View Forum Posts Registered User Join Date Aug 2003 Location Where the Surf Meets the Turf @Del Mar, CA Posts 7,776 Provided Answers: 1 >I don't see any error in the code as such. I don't see any error either. >But this is totally an irreleva
and ORA-06544 pl/sql internal error After giving the finishing touches to a PL/SQL procedure that had been haunting me for the last days, consisting primarily of one BIG implicit cursor with several subqueries and a convoluted http://oraclequirks.blogspot.com/2007/05/pls-00801-internal-error-and-ora-06544.html logic, i was finally ready to compile the program when i got this https://community.oracle.com/thread/858759?db=5 terrifying error message:Line: 1 Column: 3 Error: PLS-00801: internal error [ph2csql_strdef_to_diana:bind]Line: 7 Column: 12 Error: PL/SQL: ORA-06544: PL/SQL: internal error, arguments: [ph2csql_strdef_to_diana:bind], [], [], [], [], [], [], []Line: 7 Column: 5 Error: PL/SQL: SQL Statement ignoredOnce i recovered from the shock, i soon realized that there must be some junk i left in the SQL internal error statement that i was converting from the sqlplus format (where i developed and tested it) into a programmatic format, that is replacing substitution variables with procedure parameters and variables.From my past experience i know that when Oracle 9i complaints with a PL/SQL parser internal error, although the manual suggests to call Oracle Support and report a supposed bug, usually it's much ado about nothing, it's just a matter of a pls-00801: internal error construct that the parser doesn't like.Note that the parser doesn't point us to the precise spot where it found a problem, but it reports it as a generic problem regarding the whole SQL statement (line 7, where my UPDATE begins) , so it's up to us to find out where the offending bit is located....begin...UPDATE -- at line 7...AND L1.TYPE_CODE = 'MK' -- at line 25AND L2.TYPE_CODE = 'RE'AND AM.MD_NBR = &num_model_nbrAND L1.LOC_CODE = L2.LOC_CODEAND AM.MD_CODE = 'WK'AND MOG.USER_ID = i_var_userAND MOG.CONFIG_FLAG = 'X'AND MOG.MKT_NBR = L2.LOC_NBRAND MOG.PL_NBR = AM.PL_NBR...end;In my case, it was just a sqlplus substitution variable that i forgot to replace with its corresponding parameter, however i remember i saw this happen more than once with certain SQL statements involving function THE (aka TABLE function) inside triggers.If you want to artificially recreate this problem, try to execute the following anonymous PL/SQL block:beginupdate dual set k = k where k = &test;end;In conclusions there are situations where the PL/SQL parser seems to say: "hey look, i know there is a problem with your SQL but i can't make out exactly what it is, i give up, sorry!"The good news is that at least Oracle doesn't freeze and doesn't force you to press CTRL-ALT-DEL to restart!Se
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 Reports All PlacesDevelopment ToolsReports This discussion is archived 0 Replies Latest reply on Feb 7, 2009 7:45 AM by 664499 Iam getting the error REP-1401: '': Fatal PL/SQL error occurred. when i 664499 Feb 7, 2009 7:45 AM When i run the report to generate xml file in report builder the following error messages are displayed. REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error: REP-1401: '': Fatal PL/SQL error occurred. pls help me.Its urgent Regards, Kranthi I have the same question Show 0 Likes(0) 696Views Tags: none (add) This content has been marked as final. Show 0 replies Actions About Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3.1 , revision: 20160414082626.1619a91.release_8.0.3.x