error - Command processed but no rows were affected
Publicado por filihc (1 intervención) el 04/05/2007 00:50:39
Hola tengo el siguiente sp :
y me manda los siguientes errores alguien me puede ayudar porfavor
17:52:32 [CREATE - 0 row(s), 0.031 secs] Command processed but no rows were affected
17:52:32 [V_DOC - 0 row(s), 0.015 secs] [Error Code: 900, SQL State: 42000] ORA-00900: invalid SQL statement
17:52:32 [V_CVE - 0 row(s), 0.000 secs] [Error Code: 900, SQL State: 42000] ORA-00900: invalid SQL statement
17:52:32 [V_VERSION - 0 row(s), 0.000 secs] [Error Code: 900, SQL State: 42000] ORA-00900: invalid SQL statement
17:52:32 [BEGIN - 0 row(s), 0.000 secs] [Error Code: 6550, SQL State: 65000] ORA-06550: line 3, column 16:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
. ( * @ % & = - + ; < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_
17:52:32 [V_XML - 0 row(s), 0.016 secs] [Error Code: 900, SQL State: 42000] ORA-00900: invalid SQL statement
17:52:32 [V_CVE - 0 row(s), 0.000 secs] [Error Code: 900, SQL State: 42000] ORA-00900: invalid SQL statement
17:52:32 [SELECT - 0 row(s), 0.000 secs] [Error Code: 904, SQL State: 42000] ORA-00904: "V_CVE": invalid identifier
17:52:32 [INSERT - 0 row(s), 0.015 secs] [Error Code: 984, SQL State: 42000] ORA-00984: column not allowed here
17:52:32 [END - 0 row(s), 0.000 secs] [Error Code: 900, SQL State: 42000] ORA-00900: invalid SQL statement
... 10 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.077/0.000 sec [0 successful, 1 warnings, 9 errors]
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
CREATE OR REPLACE PROCEDURE sp_creaXML( IN VARCHAR2 xml,
IN VARCHAR2 prueba)IS
DECLARE
v_xml SYS.XMLTYPE;v_doc CLOB;
v_cve VARCHAR2(5);
v_version NUMBER;
BEGIN
v_doc := xml;
v_xml := sys.xmltype.createXML(v_doc);
v_cve := prueba;
SELECT COUNT(v_cve) INTO(v_version) FROM test_pantalla;
INSERT INTO test_pantalla (xml,version,cve_prueba) VALUES (v_xml,(v_version+1),v_cve);
END
/
y me manda los siguientes errores alguien me puede ayudar porfavor
17:52:32 [CREATE - 0 row(s), 0.031 secs] Command processed but no rows were affected
17:52:32 [V_DOC - 0 row(s), 0.015 secs] [Error Code: 900, SQL State: 42000] ORA-00900: invalid SQL statement
17:52:32 [V_CVE - 0 row(s), 0.000 secs] [Error Code: 900, SQL State: 42000] ORA-00900: invalid SQL statement
17:52:32 [V_VERSION - 0 row(s), 0.000 secs] [Error Code: 900, SQL State: 42000] ORA-00900: invalid SQL statement
17:52:32 [BEGIN - 0 row(s), 0.000 secs] [Error Code: 6550, SQL State: 65000] ORA-06550: line 3, column 16:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
. ( * @ % & = - + ; < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_
17:52:32 [V_XML - 0 row(s), 0.016 secs] [Error Code: 900, SQL State: 42000] ORA-00900: invalid SQL statement
17:52:32 [V_CVE - 0 row(s), 0.000 secs] [Error Code: 900, SQL State: 42000] ORA-00900: invalid SQL statement
17:52:32 [SELECT - 0 row(s), 0.000 secs] [Error Code: 904, SQL State: 42000] ORA-00904: "V_CVE": invalid identifier
17:52:32 [INSERT - 0 row(s), 0.015 secs] [Error Code: 984, SQL State: 42000] ORA-00984: column not allowed here
17:52:32 [END - 0 row(s), 0.000 secs] [Error Code: 900, SQL State: 42000] ORA-00900: invalid SQL statement
... 10 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.077/0.000 sec [0 successful, 1 warnings, 9 errors]
Valora esta pregunta
0