ORA-06550 and PLS-00103 error
declare  rent_paid_date DATE;  rent_due_date DATE; create or replace procedure due_date(in_rn_ssn NUMBER, in_home_id NUMBER, in_rent_paid_date DATE, in_rent_due_date DATE, in_rental_fees NUMBER) as  fees rent_collector.late_fees%TYPE;  new_fees number := 0; begin  select sum(late_fees) into fees  from rent_collector  where rn_ssn = in_rn_ssn and  home_id = in_home_id and  rent_paid_date = in_rent_paid_date and  rent_due_date = in_rent_due_date and  rental_fees = in_rental_fees;  if rent_paid_date [...]

Answer Question   |  November 18, 2010  5:24 PM
ORA-06550, Oracle, Oracle Error Codes, Oracle error messages, Oracle errors

database problem ORA-06550
declare type x is ref cursor; d x; r varchar(300); begin open d for select *from departments loop fetch d into r.last_name; exit when d%notfound; dbms_output.put_line(r); end loop; close d; end;   fetch d into r.last_name; * [/pre] يوجد خطأ عند سطر 8: ORA-06550: ¿¿¿ 7 ¿ ¿¿¿¿ 6 : PL/SQL: ORA-00933: ¿¿¿ SQL ¿¿ [...]

Answer Question   |  April 27, 2010  10:26 PM
ORA-06550, Oracle Error Codes

ORA-06550: line 224, column 7: error running in SQLPLUS
Im getting the following error when running the code below: SQL> @n377d_load_tfdscpm_sxb.sql       exception       * ERROR at line 224: ORA-06550: line 224, column 7: PLS-00103: Encountered the symbol “EXCEPTION” when expecting one of the following: begin case declare end exit for goto if loop mod null pragma raise return select update while with <an [...]

Answer Question   |  April 7, 2010  1:13 AM
ORA-06550, Oracle Error Codes, PL/SQL, SQL Execution

Ora-06550
I found this error in alert log file ora-06550 and ora-02063 please help in  to solve these issue   its urgent .

Answer Question   |  January 6, 2010  11:15 AM
ORA-06550, Oracle error messages, Oracle errors

Error ORA 06550
Hi.. I am Planning to make email automation . mail should have attachment. Attachment is the result of query execution in oracle database .I am getting error ORA 06550 and PLS 00013.Can u help me solve this glitch..Here I Put My PACKAGE.. create table config2 ( TO_ADDRESS VARCHAR2(1000), SMTP_SERVER VARCHAR2(1000), FROM_ADDRESS VARCHAR2(1000), EMAIL_SUBJECT VARCHAR2(1000), EMAIL_TEXT [...]

Answer Question   |  June 29, 2009  9:28 AM
ORA-06550, Oracle error messages, PLS-00013

SQL error
DECLARE BEGIN FOR C1 IN (SELECT A.BANK,A.BRANCH,A.MODULE,A.SCHEME,A.ACCOUNTNO,A.ACCOUNTISN,NVL(T.NEXTDUEDATE,:TDATE) NEXTDUEDATE,A.REVIEWDATE FROM ACCOUNTMASTER A,TERMLOANSDATA T WHERE A.BANK=:INPBANK AND A.BRANCH=DECODE(:INPBRANCH,’ALL’,A.BRANCH,:INPBRANCH) AND A.MODULE=:INPMODULE AND A.SCHEME=DECODE(:INPSCHEME,’ALL’,A.SCHEME,:INPSCHEME) AND A.ACCOUNTNO=DECODE(:INPACCOUNTNO,’ALL’,A.ACCOUNTNO,:INPACCOUNTNO) AND T.BANK=A.BANK AND T.BRANCH=A.BRANCH AND T.MODULE=A.MODULE AND T.SCHEME=A.SCHEME AND T.ACCOUNTNO=A.ACCOUNTNO AND T.ACCOUNTISN=A.ACCOUNTISN) loop while c1.NEXTDUEDATE<=c1.REVIEWDATE c1.NEXTDUEDATE:=add_months(c1.NEXTDUEDATE,1) dbms_output.put_line(c1.BANK||’ ‘||c1.BRANCH||’ ‘||c1.MODULE||’ ‘||c1.SCHEME||’ ‘||c1.ACCOUNTNO||’ ‘||c1.ACCOUNTISN||’ ‘||c1.NEXTDUEDATE||’ ‘||c1.REVIEWDATE); end loop; END; ORA-06550: line 16, column 1: PLS-00103: [...]

Answer Question   |  May 28, 2009  5:49 AM
ORA-06550, Oracle error messages, SQL

Oracle coding error ORA-06550
Hi, I get the following error on compiling my code - *********************************************************** ORA-06550: line 16, column 1: PLS-00103: Encountered the symbol “ELSE” when expecting one of the following: begin case declare end exit for goto if loop mod null pragma raise return select update while with <an identifier> <a double-quoted delimited-identifier> <a bind variable> << [...]

Answer Question   |  July 18, 2008  2:59 PM
ORA-06550, Oracle development, Oracle error messages

ORA-06550 error: the function is undefined or not a procedure, yet I have defined the function
I get the following error message: ORA-06550: line 2, column 1: PLS-00221: ‘CUSTOM_AUTH’ is not a procedure or is undefined ORA-06550: line 2, column 1: PL/SQL: Statement ignored Error ERR-10460 Unable to run authentication credential check function. I have defined the function custom_auth

Answer Question   |  May 26, 2010  1:24 AM
ORA-06550, PL/SQL, Undefined Function

How do you get around an ORA-06550 error?
I am making a program that will ask the user to enter a customer number. All of the customer numbers are numbers only. If the user enters in a customer number with a letter in it by mistake they will receive an ora-06550 error on that line number. How can I create an exception that [...]

Answer Question   |  April 18, 2013  4:52 PM
ORA-06550, Oracle 10g, Oracle error messages