Ora-06550 Line 0 Column 0 Pls-00801 Internal Error
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings ora-06544 pl/sql internal error arguments and policies of this site About Us Learn more about Stack Overflow pls-00801: internal error [ph2csql_strdef_to_diana:bind] the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags pls-00801: internal error [phdcsql_print_kge_errors::parm pos] Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only
Pls-00801: Internal Error [hshuid:lu Invalid]
takes a minute: Sign up What is substitution variable in PL/SQL? up vote 1 down vote favorite I'm using this code to enter the name of the department using substitute variable. DECLARE MAX_DEP_VAR NUMBER; BEGIN SELECT MAX(DEPTNO) INTO MAX_DEP_VAR FROM DEPT; INSERT INTO DEPT VALUES(MAX_DEP_VAR+10, &DEPTNAME, NULL); END; But it gives this error: ORA-06550: line 0, column 0: PLS-00801: internal ora 06553 pls 801 error [ph2csql_strdef_to_diana:bind] ORA-06550: line 6, column 13: PL/SQL: ORA-06544: PL/SQL: internal error, arguments: [ph2csql_strdef_to_diana:bind], [], [], [], [], [], [], [] ORA-06550: line 6, column 1: PL/SQL: SQL Statement ignored plsql share|improve this question edited Nov 18 '13 at 17:55 gunr2171 5,687103160 asked Nov 18 '13 at 17:35 user3005624 62 You are running this script in sqlplus, and are referencing a variable, &DEPTNAME, which is not declared anywhere. Go read this - docs.oracle.com/cd/B19306_01/server.102/b14357/ch5.htm and this cs.csub.edu/~hwang/CS342/SqlPlus.htm –OldProgrammer Nov 18 '13 at 18:23 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote Here's one way to generate the error you're seeing (Oracle XE 11.2.0.2.0, Windows 8.1 x64): SQL> DEFINE deptname=": abc" SQL> CREATE OR REPLACE TRIGGER test_trigger 2 AFTER UPDATE ON DEPT 3 FOR EACH ROW 4 BEGIN 5 DECLARE 6 MAX_DEP_VAR NUMBER; 7 BEGIN 8 SELECT MAX(DEPTNO) INTO MAX_DEP_VAR 9 FROM DEPT; 10 INSERT INTO DEPT 11 VALUES(MAX_DEP_VAR+10, &DEPTNAME, NULL); 12 END; 13 END; 14 / old 11: VALUES(MAX_DEP_VAR+10, &DEPTNAME, NULL); new 11: VALUES(MAX_DEP_VAR+10, : abc, NULL); Warning: Trigger created with compilation erro
error [phdcsql_canonical_sql] If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you ora-06550 line 0 column 0 pls-00907 cannot load library unit 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: PLS-00801: internal error [phdcsql_canonical_sql] Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 04-23-2009,12:08 http://stackoverflow.com/questions/20054112/what-is-substitution-variable-in-pl-sql PM #1 jreyesb View Profile View Forum Posts Junior Member Join Date Apr 2009 Posts 3 PLS-00801: internal error [phdcsql_canonical_sql] Hi again Using a query like this: Code: INSERT INTO OM_DB.CDRS_VALIDOS_TMP ( SELECT FROM ( SELECT FROM ( SELECT FROM ( ..... ) ) FULL OUTER JOIN ( SELECT .... ) ) ) I receive this errors: ORA-06550: line 0, column 0: http://www.dbasupport.com/forums/showthread.php?59674-PLS-00801-internal-error-phdcsql_canonical_sql PLS-00801: internal error phdcsql_canonicalize_sql:state, Batch 1 Line 1 Col 1 Now, trust me, all the SELECT statement its ok, because i probe just that part and its working, but when i try to insert that set into the OM_DB.CDRS_VALIDOS_TMP table it doesnt work, i hear something about a bug on this version, thats my only clue, any idea? This are the oracle settings: "Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi" "PL/SQL Release 10.2.0.3.0 - Production" "CORE 10.2.0.3.0 Production" "TNS for Solaris: Version 10.2.0.3.0 - Production" "NLSRTL Version 10.2.0.3.0 - Production" Thanks in advanced. Reply With Quote 04-23-2009,12:32 PM #2 LKBrwn_DBA View Profile View Forum Posts Senior Advisor Join Date Jul 2002 Location Lake Worth, FL Posts 1,492 No comment(s) Compilation of PL/SQL procedures/blocks can fail when they contain static sql which includes extra white space and/or comments. (Oracle bug) A PLS-00801 from compiling a Stored Procedure is due to an ERROR in the canonical parsing Oracle is doing. Set the following event which is a "workaround" to the problem: Add event="10946 trace name context forever, level 64" into the init.ora f
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 https://community.oracle.com/thread/2558962 on and reload this page. Please enter a title. You can http://forums.devart.com/viewtopic.php?t=23701 not post a blank message. Please type your message and try again. More discussions in PL/SQL and SQL All PlacesDatabaseDatabase Application DevelopmentPL/SQL and SQL This discussion is archived 4 Replies Latest reply on Jul 10, 2013 11:39 PM by rp0428 Execute Immediate with internal error FORALL Debadatta Kar Jul 10, 2013 7:17 PM Hello All,I am running the following pl/sql block and getting error as given below:DECLARE CURSOR C1 IS SELECT 'DELETE FROM '||(CASE(rnw.module_name) WHEN 'PSIRT' THEN 'r_psirt_wh_excep WHERE psirt_wh_id=' WHEN 'CBP' THEN 'r_cbp_wh_excep WHERE cbp_wh_id=' WHEN 'CCF' THEN 'r_ccf_wh_excep WHERE ccf_wh_id=' WHEN 'SLG' THEN 'r_slg_wh_excep WHERE pls-00801: internal error slg_wh_id=' WHEN 'CNA' THEN 'r_cna_wh_excep WHERE cna_wh_id=' WHEN 'SIAR' THEN 'r_siar_wh_excep WHERE siar_wh_id=' WHEN 'EOX' THEN 'r_eox_wh_excep WHERE eox_wh_id=' WHEN 'FN' THEN 'r_fn_wh_excep WHERE fn_wh_id=' WHEN 'MANUAL' THEN 'r_manual_wh_excep WHERE manual_wh_id=' END) || rnw.module_wh_id delete_stmt FROM r_nip_wh rnw WHERE rnw.nip_wh_id IN (24414932,24417670,24415041,24420904,24418207,24412051,24418725) AND rnw.party_id = 81714 AND EXISTS (SELECT 1 FROM r_nip_status_mas rnsm WHERE rnsm.status_id = rnw.status_id AND rnsm.status_name IN ('Internal - Resolved', 'Appears Resolved', 'Internal - Appears Resolved')); TYPE del_tab_typ IS TABLE OF c1%ROWTYPE; del_tab del_tab_typ; BEGIN OPEN c1; LOOP FETCH c1 BULK COLLECT INTO del_tab LIMIT 100; EXIT WHEN del_tab.COUNT = 0; FORALL i IN del_tab.FIRST .. del_tab.LAST EXECUTE IMMEDIATE del_tab(i).delete_stmt; DBMS_OUTPUT.PUT_LINE(SQL%ROWCOUNT); END LOOP;END;ORA-06550: line 29, column 13:PLS-00801: internal error [*** ASSERT at file pdw4.c, line 3579; Can't handle Object = -2147483537 in D_S_ED -2147483580.; Xanon__0x121b2da60__AB[29, 13]]If I am trying to hard code the table name and column name, it's working. I have written this kind of NDS before but all of them worked. This time, the datab
PLS-00801 Post a reply 4 posts • Page 1 of 1 Problem with tables and fields names on russian - PLS-00801 by Boris! » Thu 22 Mar 2012 08:02 Hello! I have migrated from ODAC version 6.90 to version 8.1.5 and now I have a following problem with inserting records by OraQuery in tables with names on russian language. Their fields also have names on russian language. I'm using a Direct mode. In OraQuery I do select from that table. Query for example: Code: Select allselect
Код_табл1,
Поле_число,
Поле_строка
from табл1In OraQuery property KeyFields set to key field - in example it Код_табл1. Property KeySequence set to sequence in database, from which values for key field should be taking.When I try to insert new record in OraQuery on calling Post() method I get an error: Code: Select allORA-06550: line 0, column 0:
PLS-00801: internal error [ph2csql_strdef_to_diana:bind]
ORA-06550: line 1, column 20:
PL/SQL: ORA-06544: PL/SQL: internal error, arguments: [ph2csql_strdef_to_diana:bind], [], [], [], [], [], [], []
ORA-06550: line 1, column 7:
PL/SQL: SQL Statement ignoredUpdating record work successfully.If I create aliases for fields and table, like this:Code: Select allselect
Код_табл1 ID,
Поле_число Fld_num,
Поле_текст Fld_txt
from табл1 Tabl1 when inserting work well. But I have many oqueries, which using tables and fields on russian names, so I will need to make many changes to solve problm in this way. Regards, Boris Boris! Posts: 2Joined: Thu 22 Mar 2012 07:39 Top by AlexP » Thu 22 Mar 2012 11:05 Hello, Thank you for the information. We have reproduced the problem. We will try to fix it in the nearest product version. AlexP Devart Team Posts: 5431Joined: Tue 10 Aug 2010 11:35 Top Re: Problem with tables and fields names on russian - PLS-00801 by AlexP »