Ora-06544 Pl/sql Internal Error Arguments 78502
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions ora 06544 pl sql internal error arguments 77604 you might have Meta Discuss the workings and policies of
Pls-00801: Internal Error [ph2csql_strdef_to_diana:bind]
this site About Us Learn more about Stack Overflow the company Business Learn more about hiring ora-06553 pls-801 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 ora-06553: pls-801: internal error [56327] community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up passing associative array of type Timestamp to oracle stored procedure up vote 1 down vote favorite 1 We're running into a strange error using Oracle Odp.Net (connecting to Oracle 9). The problem is
Ora 06544 Pl Sql Internal Error Arguments 56327
illustrated by the code snippet below. This is the error we're experiencing: ORA-00600: internal error code, arguments: [15419], [severe error during PL/SQL execution], [], [], [], [], [], [] ORA-06544: PL/SQL: internal error, arguments: [78502], [], [], [], [], [], [], [] ORA-06553: PLS-801: internal error [78502] Googling around makes us suspect (though we're not entirely sure) that passing an array of Timestamps is not supported by Odp.Net. So the question is 2-fold: is it possible to pass an array of timestamp to a pl/sql procedure using odp.net? if not, is there a good workaround available? C# console program illustrating the problem: using System; using System.Collections; using System.Data; using Oracle.DataAccess.Client; class Program { private const string _db = "
ORA-06544: PL/SQL: ora-06544: pl/sql: internal error, arguments: [77303], [], [], [], [], [], [], [] internal error, arguments: If this is your pls-00801: internal error [phdcsql_print_kge_errors::parm pos] first visit, be sure to check out the FAQ by clicking
Ora-06553 Pls-801 Internal Error 55018
the link above. You may have to register before you can post: click the register link above to proceed. http://stackoverflow.com/questions/1554389/passing-associative-array-of-type-timestamp-to-oracle-stored-procedure 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 Show Printable Version Email this http://www.dbasupport.com/forums/showthread.php?52534-PL-SQL-ORA-06544-PL-SQL-internal-error-arguments 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, issue_visibility,fin_account_id,target_close_date,target_close_date2,compl_cause, compl_cause_entity,claim_date,claim_date_to,claim_submitted_by,claim_paid_date, claim_paid_date_to,compl_close_reason,compl_received_via,rbtacctno,rbtacctid, rctinstphoneno) VALUES(:new.oprid,:new.rc_case_query,:new.rc_case_mode,:new.rc_vertical,:new.market, :new.dttm_stamp,:new.case_id,:new.business_unit,:new.rc_pin_sin_flg,:new.person_pin, :new.sin,:new.cust_id,:new.name1,:new.case_contact,:new.name_search,:new.bo_id_cust, :new.role_type_id_cust,:new.bo_name,:new.bo_id_contact,:new.role_type_id_cntct, :new.bo_name_2,:new.emplid,:new.deptid,:new.rc_dept_descr,:new.location, :n
us Login or Register ASK A QUESTION QuestionsBadgesCategoriesTagsUsers ©2016 site design / logo © 2015 qaoverflow.com; user contributions licensed under cc by-sa 3.0 http://qaoverflow.com/question/how-to-pass-clobs-to-oracle-in-a-plsqlassociativearray/ with attribution required Terms & Privacy Home How to Pass CLOBs to Oracle in a PLSQLAssociativeArray 0 Does anyone know how to pass an array http://cooder.org/questions/tagged/odp.net?p=49 of CLOBs to Oracle? I've no trouble passing in strings and numbers.Here's a code snippet:using (var con = new OracleConnection(AppSettings.OracleConnection)) { using (OracleCommand cmd = new internal error OracleCommand()) { cmd.Connection = con; cmd.CommandText = "MyProcName"; cmd.CommandType = CommandType.StoredProcedure; var p = cmd.Parameters.Add("SessionIds", OracleDbType.Varchar2,ParameterDirection.Input); p.CollectionType = OracleCollectionType.PLSQLAssociativeArray; p.Value = MyListOfKeyStrings; p.Size = MyListOfKeyStrings.Count; p = new OracleParameter("UserDataXml", p.OracleDbType = OracleDbType.Clob, ParameterDirection.Input); p.CollectionType = OracleCollectionType.PLSQLAssociativeArray; p.Value = MyListOfLargeStrings.ToArray(); p.Size = MyListOfLargeStrings.Count; cmd.Parameters.Add(p); con.Open(); cmd.ExecuteNonQuery(); } } Here's the obscure Oracle error internal error arguments when I try to pass in CLOBscmd.ExecuteNonQuery() error thrown is: ORA-00600: internal error code, arguments: [15419], [severe error during PL/SQL execution], [], [], [], [], [], [], [], [], [], [] ORA-06544: PL/SQL: internal error, arguments: [78502], [], [], [], [], [], [], [] ORA-06553: PLS-801: internal error [78502] Thanks for your help. CBlack Asked on August 18, 2014 in No Category. This question was posted in Stack Exchange Share Comment(0) Add Comment Add comment Cancel 0 Answer(s) Votes Oldest Your Answer Post answer By posting your answer, you agree to the privacy policy and terms of service. Sign In Username or Email Password Forgot password Enter your email here Reset Password Enter your new password here Report Your message Insert/edit link CloseEnter the destination URL URL Link Text Open link in a new tabOr link to existing content Search No search term specified. Showing recent items. Search or use up and dow