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 [...]
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 ¿¿ [...]
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 [...]
I found this error in alert log file ora-06550 and ora-02063 please help in to solve these issue its urgent .
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 [...]
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: [...]
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> << [...]
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
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 [...]





