Error Ora-6544
Contents |
ORA-06544: PL/SQL: internal error, arguments: If this
Pls-00801: Internal Error [ph2csql_strdef_to_diana:bind]
is your first visit, be sure to check out the FAQ ora-06544 pl/sql internal error arguments 77604 by clicking the link above. You may have to register before you can post: click the register link
Ora-06553 Pls-801
above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 4 of 4 Thread: PL/SQL: ORA-06544: PL/SQL: internal error, arguments: Tweet Thread Tools ora-06544: pl/sql: internal error, arguments: [77303] Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 08-26-2006,08:32 AM #1 arul2004 View Profile View Forum Posts Junior Member Join Date Aug 2006 Posts 2 PL/SQL: ORA-06544: PL/SQL: internal error, arguments: Hi All, I have executed the following trigger CREATE OR REPLACE TRIGGER delta_ps_rc_case_qry_trig AFTER INSERT OR UPDATE ON ps_rc_case_qry FOR EACH ROW DECLARE flag VARCHAR2(10) := 'TRUE'; v_oprid VARCHAR2(90); v_rc_case_query VARCHAR2(120); v_rc_case_mode VARCHAR2(3); v_rc_vertical VARCHAR2(12); v_market VARCHAR2(9); CURSOR c1 IS SELECT oprid,rc_case_query,rc_case_mode,rc_vertical,market FROM ps_rc_case_qry_jcm; BEGIN IF INSERTING THEN INSERT INTO ps_rc_case_qry_jcm (oprid,rc_case_query,rc_case_mode,rc_vertical,market,dttm_stamp,case_id,business_unit, rc_pin_sin_flg,person_pin,sin,cust_id,name1,case_contact,name_search,bo_id_cust, role_type_id_cust,bo_name,bo_id_contact,role_type_id_cntct,bo_name_2,emplid,deptid, rc_dept_descr,location,rc_loc_descr,physical_location,rc_cm_cust_rep_flg,rc_phone_cust, extension_cust,email_addr_cust,rc_phone,extension,email_addr,provider_grp_name, name_assigned_to,case_type,rc_source,contact_id,rc_status,rc_severity,rc_priority, problem_type,competency,quick_cd,rc_category,rc_type,rc_detail,closed_date_from, closed_date_to,creation_date_from,creation_date_to,inst_prod_id,serial_id,product_id, assettag,provider_grp_id,assigned_to,rc_match_case,rc_tracking_nbr,issue_subtype, is
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have
Pls-00801: Internal Error [phdcsql_print_kge_errors::parm Pos]
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.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle http://www.dbasupport.com/forums/showthread.php?52534-PL-SQL-ORA-06544-PL-SQL-internal-error-arguments VideosOTN DocumentationOTN Search ResultsSearch forSearch forContentSearch forPeopleSearch forPlacesLast modifiedLast modifiedAll timeLast modified1 dayLast modified7 daysLast modified30 daysLast modified90 daysLast modified1 yearSort byRelevanceRelevanceLast modifiedLast modifiedRestrict results byRestrict results by: PeopleRestrict results by: PlacesSubspace depthSubspace https://community.oracle.com/community/developer/search.jspa?q=ORA-06544 depthNo subspacesSubspace depthChild subspacesSubspace depthAll subspacesMatchingMatch names onlyDeactivated UsersShow/HideShowShowAll contentShowBlog postsShowDocumentsShowDiscussionsShowPollsShowIdeasShowStatus updatesShowMessagesShowExternal activityShowShowAll placesShowSpacesShowProjectsShowGroupsContent marked asShowAll ContentShowFinalShowReservedShowCommunity RecommendedShowOutdatedShowAction ItemShowDecisionShowHelpfulShowResolvedShowCommunity Feedback RequestedSocial Search On/OffSearchSearch TipsView more results from Oracle BlogsView more results from Oracle University TrainingView more results from Oracle VideosView more results from OTN DocumentationView more results from OTN Search ResultsAbout 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
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 terrifying http://www.orafaq.com/forum/t/177986/ 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 statement internal error 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 construct ora-06544 pl/sql internal 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!See message translat
Today's Messages :: Show Polls :: Message Navigator E-mail to friend ORA-06544: PL/SQL: internal error, arguments: [ph2_cly out of bounds in PH2POP.], [0], [1240], [], [ [message #539044] Wed, 11 January 2012 01:47 ramoradba Messages: 2454Registered: January 2009 Location: AndhraPradesh,Hyderabad,I... Senior Member -bash-3.00$ sqlplus sys as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Tue Jan 10 23:19:18 2012 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Enter password: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select * from v$instance; INSTANCE_NUMBER INSTANCE_NAME --------------- ---------------- HOST_NAME ---------------------------------------------------------------- VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT ----------------- --------- ------------ --- ---------- ------- --------------- LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO ---------- --- ----------------- ------------------ --------- --- 1 xxxxxxxx xxxxxxxx 10.2.0.5.0 24-DEC-11 OPEN NO 1 STOPPED ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO SQL> We have recently Upgraded from 10.2.0.1 to 10.2.0.5 On Our Dev Environment. While compiling an Invalid "Procedure" We got Quote:dev> sho err Errors for PROCEDURE xxxxxxxxxxxxxxxxxxxxxx: LINE/COL ERROR -------- ----------------------------------------------------------------- 0/0 ORA-06544: PL/SQL: internal error, arguments: [ph2_cly out of bounds in PH2POP.], [0], [1240], [], [], [], [], [] No errors in alert_log. Verified with Oracle Support about it and found that its Bug on 10.2.0.5 and there is no workaround available for it.And this has been fixed in V 12.1. Source Bug 10400244 [ID 1358114.1] Does anyone encountered with this Error ? Sriram Sanka Edit:Just Read the Doc carefully and Got resolved this Error.fixing errors Other than Internal does n`t report this Error. [Updated on: Wed, 11 January 2012 02:06]Report message to a moderator Previous Topic: Invalid component on 10.2 database(2 Merged) Next Topic: Database up