1
  • 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 will allow me to...

    Jonsorr20 pointsBadges:
  • 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...

    Kuranharuka75 pointsBadges:
  • 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

    T Will5 pointsBadges:
  • 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...

    Aiman1115 pointsBadges:
  • 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...

    Catch9315 pointsBadges:
  • Ora-06550

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

    5352369175 pointsBadges:
  • 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),...

    Nidi915 pointsBadges:
  • 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...

    Shindetanaji10 pointsBadges:
  • 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...

    ITKE54,840 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following