Oracle ERROR en linea 1: ORA-06550: linea 1, columna 32: PLS-00103: Se ha encontra

Good night,
I hope they are super good,
I have a procedure that is executed very well, I kept the information to the right place, but now that I come to run generates the following error.

ERROR at line 1:
ORA-06550: line 1, column 32:
PLS-00103: Symbol has been found

Thank for their collaboration, to resolve this error ...
GOOD DAY


Create or replace Procedure Lectura_Gases_occidente( Nom_archivo varchar2 )
As
v1 utl_file.file_type;
v2 varchar2(900);
aux varchar2(20);
vlr number;
ndoc varchar2(20);
aux1 number; -- lleva el valor de caracteres de la variable VLR...
fec date;
avlr number;
ser number;
cont number;
anom varchar2(100);
Begin
v1 := utl_file.fopen('PUBLIC_ACCESS', Nom_archivo, 'r');
--avlr := 0; ser := 1; anom := v1;
select sysdate
into fec
from dual;
cont :=0; avlr := 0;
loop
begin
utl_file.get_line(v1,v2);
dbms_output.put_line('el contenido del archivo es: '||v2);
select substr(v2, 7, 12), substr(v2, 19, 8), substr(v2, 43, 7)
into vlr, ndoc, aux
from dual;
avlr := avlr + vlr;
aux1 := (length(vlr)-2); -- procedimiento para quitar los decimales...
vlr := substr(vlr,1,aux1);
insert into g_occidente (DETALLE,VALOR_FACTURA,NUM_FACTURA,TIPO_PAGO,FECHA_CREACION)
values (v2, vlr, ndoc, aux, fec);
-- dbms_output.put_line('El contenido del archivo es: '||v2);
-- dbms_output.put_line(' ');
-- dbms_output.put_line('El nombre del archivo es: '||Nom_archivo); -- agregado 12052009
cont:= cont + 1;
-- dbms_output.put_line('El total de registros es: '||cont); -- agregado 12052009
-- dbms_output.put_line(' ');
-- dbms_output.put_line('El valor del archivo es de: '||avlr); -- agregado 12052009
exception
when no_data_found then
exit;
end;
end loop;
-- lineas para guardar los nombre de los archivos ->12052009...
insert into ARCHIVOS_GUADADOS_GASES (Nomb_archivo,total_registro,vlr_archivo) values(Nom_archivo, cont, avlr);
--insert into nombre_archivo(nombre, valor, servicio) values (v1, avlr, ser);
utl_file.fclose(v1);
exception
when others then
dbms_output.put_line(sqlerrm);
end;
/

SQL> set serverout on;
SQL> EXECUTE Lectura_Gases_occidente(C:\ARCHIVOS_LECTURA_XE\7061232125062009181820);
BEGIN Lectura_Gases_occidente(C:\ARCHIVOS_LECTURA_XE\7061232125062009181820); END;

*
ERROR en linea 1:
ORA-06550: linea 1, columna 32:
PLS-00103: Se ha encontrado el sÝmbolo ":" cuando se esperaba uno de los siguientes:
. ( ) , * @ % & | = - + < / > at in is mod remainder not
range rem => .. <an exponent (**)> or != or ~= >= <= <>
and or like LIKE2_ LIKE4_ LIKEC_ as between from using ||
multiset member SUBMULTISET_

SQL>

IN ADVANCE I thank everyone whom I have worked with my concerns ...


REYNEL SALAZAR MARTINEZ

Oracle Error while executing procedure : ORA-06550 and PLS-00103

I have created the Stored Procedure as, CREATE OR REPLACE PACKAGE BODY APPS.TMP_IMPORT_ITEMS_PKG AS     PROCEDURE LOAD_INTERFACE_TABLE(organization_code IN VARCHAR2, errbuf OUT VARCHAR2, retcode OUT NUMBER) IS     org_code varchar2(3);     BEGIN     org_code:= ...

Error at line 1 ORA-06550: line 1, column 7: PLS-00306:

I trying to create an procedure using the below code... create or replace NEW_PROC (cnt out number) isdeclare cnt integer;beginselect count(*) into cnt from table;end;------But I am getting the below error...Error(1): PL/SQL: Compilation unit analysis terminatedError(2,1): PLS-00410: duplicate field ...

Oracle ORA-06550: line 1, column 7: PLS-00103: Encountered the symbol "CREATE" whe

Can someone give a solution for the below?I created an application using html db.Iam trying to execute on click of button a set of ddl actions as simple as the belowdrop sequence seq123;create sequence seq123;and i get the error message"ORA-06550: line 1, column 7: PLS-00103: Encountered the symbol ...

Oracle Apex login page - ORA-06550: line 2, column 0: PLS-00103

i have this error after installing XE (on DB login page):run http://127.0.0.1:8080/apex/apexand seeORA-06550: line 2, column 0: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: begin case declare exit for goto if loop mod null pragma raise return select update whi ...

Oracle Migration is giving problems (ORA-06550: line 1, column 57: PLS-00307)

After migration from 2.2 to 3.0 an application I did (http://apex.oracle.com/pls/otn/f?p=38266 morce/mmmm) it worked well on Oracle apex server, but in our production server I keep having problems to run it. The last one is quite weird.One of the pages crashes when I use TO_CHAR with the following m ...

Oracle ORA-06550: line 2, column 6: PLS-00103:

this code is resulting inthe following error .i have return this code in the process lcnt number(5);beginselect nvl(count(*),0) into lcnt from passwhere username != :p2_usernameand password = :p2_password and :p2_password= :p2_confirmpassword;if lcnt > 0 thenreturn true;elsereturn false;end if;ex ...

Oracle ORA-06550: line 5, column 57: PLS-00103: Encountered the symbol "F01_" when

I wanted to use the APEX_ITEM.DISPLAY_AND_SAVEHere is my query:DECLAREQUERY VARCHAR2 (2000);BEGINQUERY := 'SELECT ' ||'APEX_ITEM.DISPLAY_AND_SAVE(1,REGISTRATION_ID,'f01_'||ROWNUM, NULL) REGISTRATION_ID, '||'APEX_ITEM.DISPLAY_AND_SAVE(2,STATUS,'f02_'||ROWNUM, NULL) STATUS, '||'APEX_ITEM.DISPLAY_AND_S ...

Oracle ORA-06550: line 1, column 24: PLS-00103: Encountered the symbol ","

I compiled the following script in toad, 0 compiled errors. However, when i called it as a function in workflow, i hit this workflow error msg:Failed Activity Find Submit ToUsers Activity Type Function Error Name -6550 Error Message ORA-06550: line 1, column 24: PLS-00103: Encountered the symbol "," ...

Oracle Help: java.sql.SQLException: ORA-06550: line 1, column 7: ,PLS-00201:

Who can give me hands for resolving below issue? I use the 11G db before couple of days. It works. But now it displayed below information, It block my application server to be up. Anyone can help take a look? And explain for me what's meaning with below issue?Thanks java.sql.SQLException: ORA-06550: ...

Oracle AUTOMATED ROW FETCH - ORA-06550: line 1, column 27: PLS-00103: Encountered

HiI have a form on which I am creating a set of card details to be written to a table which has a hidden primary key called CARD_SERIAL dervied from a sequence. What I want to have happen is to be able to create the record, save it, then have the record displayed so I can amend it if necessary. An e ...

Oracle java.sql.SQLException: ORA-06550: line 1, column 28:PLS-00103: Encountered

I did a couple of things like fix the type that was being passed etc., and I get this exception nowjava.sql.SQLException: ORA-06550: line 1, column 28:PLS-00103: Encountered the symbol "COMPUTER" when expecting one of the following:. ( ) , * @ % & = - + < / > at in is mod remainder not rem ...

ORACLE ERROR : [ORA-06550: line 1, column 7:PLS-00201: identifier

Created a package successfully but when executed this error is generatedORACLE ERROR : [ORA-06550: line 1, column 7:PLS-00201: identifier 'FINCONREP1.GLREPORT1' must be declaredORA-06550: line 1, column 7:PL/SQL: Statement ignoredPlease helpMessage was edited by: ebimiere ...

Oracle Error running initjvm.sql ORA-03113: end-of-file on communication channel

I recently was running initjvm.sql when mynetwork took a power hit. My Oracle machine was thus powered down in the middle ofrunning initjvm.sql.Now, when I run the script I get an ORA-03113: end-of-file on communication channel error every time. It alway happensduring the command "create or replace ...

Oracle ERROR at line 1:ORA-00928: missing SELECT keyword

I am new to oracle I am working with the Oracle Press book the complete reference and the appendix has samples I am trying to create these tables for example CUSTOMER: rem Requires that the ADDRESS_TY and PERSON_TY types alreadyrem exist.create table CUSTOMER (Customer_ID NUMBER,Person PERSON_TY);in ...

Oracle Error in Database Creation(ORA-00400) - Urgent

Oracle: 9.2.0.0(DB Release II)Windows NT ServerI have successfully installed Oracle when I choose software only .Then I ran the Database Configuration Assistant (dbca) to create a new database . When it is about 46% complete I get the ORA-00400 error "invalid release value string for parameter strin ...

Oracle error loading catalog.sql ORA-00060: deadlock

I forgot to shutdown all DB connections/jobs before loading catalog.sql in 9i and it reported error ORA-00060: deadlock detected while waiting for resource.now whenever I bring up the DB it says :Database mounted.ORA-00604: error occurred at recursive SQL level 1ORA-04045: errors during recompilatio ...

Oracle ERROR at line 1:ORA-06502: PL/SQL: numeric or value error: character string

I knew the reason behind this exception. But my procedure is clean and this exception is thrown, only when i call my procedure for the first time. When I invoke (thru JDBC/ SQLPLUS) the same procedure next time it is executed successfully. I have no clue why this is happening. Has anyone came across ...

Oracle Why am I getting ORA-06550?

I have build the P400 so it is similar to sample aplication’s P400. Moreover I have defined my global application item ‘g_customer_name’ as follow:G_CUSTOMER_NAME Application: Page: 400However, when I run page 400 I get:Error ERR-1030 Error executing computation expression. OK ORA-065 ...

Oracle ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments

This is Ali Kazim, Web Application Developer based in Pakistan. I'm developing a web application using ASP.net having Oracle 9i as database of choice. I have a developed a stored procedure in Oracle to add a record in the database table. Here is my schema:SQL> desc tbl_inventory_catsName Null? Ty ...

Oracle ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments

This is Ali Kazim, Web Application Developer based in Pakistan. I'm developing a web application using ASP.net having Oracle 9i as database of choice. I have a developed a stored procedure in Oracle to add a record in the database table. Here is my schema:SQL> desc tbl_inventory_catsName Null? Ty ...

Oracle ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments

This is Ali Kazim, Web Application Developer based in Pakistan. I'm developing a web application using ASP.net having Oracle 9i as database of choice. I have a developed a stored procedure in Oracle to add a record in the database table. Here is my schema:SQL> desc tbl_inventory_catsName Null? Ty ...

Oracle ORA-06550: line 1, column 8:.PLS-00201

When I call stored procedure from cobol program on vms it is giving me oracle error ORA-06550: line 1, column 8:.PLS-00201. If I execute the same procedure from toad it works fine. What could be the reason. ...

Oracle Error creating materialized view : ORA-01031: insufficient privileges

I am trying to create a materialized view using following script.create materialized view sw_device_vbuild immediaterefreshcomplete with rowidon demandenable query rewriteasselect customer_id cust_id, b.techgeo techgeo,rtrim(segment1,' ') device_id,rtrim(a.process,' ')process from apps.cmfcst_bom_ge ...

Oracle Error In Analyzing Table (Ora-03114 & ORA-00603)

While analyzing a huge table from “Analyze Table Table_Name compute statistics;” I got following errors after long query processing.When execute from network access: ORA-03114 Not connected to Oracle When execute from database host machine: ORA-00603 Oracle server session terminated by fatal error ...

Oracle ORA-06550: line 1,column 52: PLS-00405:subquery not allowed in this context

Hi! I made an item validation, but I've got this error. Does anyone know why? Am I not suppose to use a subquery in a validation item or what? My query looks like that::P1_START_DATE < (select date from my_tablewhere id_table = :P1_ID) ...

Oracle ORA-06550: line 1, column 45: PLS-00221: not a procedure or

ORA-06550: line 1, column 45: PLS-00221: 'CHECK_TAG' is not a procedure or is undefined ORA-06550: line 1, column 45: PL/SQL: Statement ignoredError ERR-1024 Unable to run "function body returning text" validation. OK I have created a simple function, which is used to validate a field. It is defined ...

Oracle ERROR at line 1:ORA-00600: internal error code, arguments: [ktsircinfo_num1

I need one help. In our one schema we have design like one temp and one parmanent table. The parmanent table is partition and we are used to exchange this partition with temporary table. It was working fine but since last many days we are facing a issue that while exchanging the table partition or c ...

Oracle Error Occurrd RMAN-03009 / ORA-19504 / ORA-27054 while trying rman backup

Refer following details errors !!!We are getting following error message while trying to execute rman script ============= Error =============================channel d3: starting piece 1 at 27-MAR-07RMAN-03009: failure of backup command on d2 channel at 03/27/2007 15:59:27ORA-19504: failed to create ...

Oracle Error in Array DML : ORA 24381

While trying to do the BULK INSERT using setMaxIterationand addIteration , I am getting the above Error ONLY if the number of rows exceeds say 60,000 ... ???Please Help ...