Oracle Tag Directory

Browse Alphabetically:

Featured Oracle Questions

  • I am getting ORA-01422: Exact fetch returns more than requested number of rows

    Hi experts, I am getting this error when I run my test case for my PL/SQL procedure, which has select and insert statements only. Not clear where I would have went wrong, Please guide me where should I check exactly. Its popping up with this error message which i caught in a exception piece after...

    Inprise610 pointsBadges:
  • 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 error

    Hi, when Exporting one of the Tables I faced with these errors: EXP-00056: Oravle error 12801 ora-12801: error signaled in parallel query server p003. ora-00028: your session has been killed. I appreciate if you would help me.

    yara858750 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-12541; TNS No listener error

    tns no listener error showing  

    Helppleaseit10 pointsBadges:
  • Getting the error unable to perform query ora 00904 on an item of previous form which is already deleted.

    using oracle 6i i save as a form to make another one and deleted all the items,triggers and other programme units,lovs from it. I added new items and new data source to its block. But its giving the error unable to perform query ora 00904 on an item of previous form which is already deleted. I have...

    Mariaali10 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:
  • ORA-01033 : Oracle startup or shutdown in progress

    We are getting this error while accessing the Database. Tried restarting the server and "the alter database open" command throws error: ORA-01122: database file 6 failed verification check ORA-01110: data file 6: 'G:ORACLE102DBCITI10DATAQCSITEADMIN' ORA-01251: Unknown File Header Version read for...

    Aloksarda5 pointsBadges:
  • following error when logging into SQLPlus

    When i try to log into Oracle SQL*Plus i get the following error ORA-01034: Oracle not available ORA-27101: shared memory realm does not exist I'm using Oracle 9i Personal Edition

    Oracle9995 pointsBadges:
  • SQL Developer: missing expression on insert into with select rownum

    insert into TEMPLE_BDMS.TEMP_QSP values ( select rownum as uniqrownum, doc_id, doc_type, barcode2, barcode3, barcode4, routing_status, scan_date, assignee, scanner, scan_station, pfile_name, new_doc_id, new_doc_type, new_doc_type2 from TEMPLE_BDMS.QSP_SOURCE where pfile_name not like '%_0001.%' ) I...

    APB10 pointsBadges:
  • Filemaker Pro 9 ODBC ORA-00936 error

    I can see all of my tables in an Oracle dbase. For two of them, I can see the actual values. On another table, I can see the fields but the actual values return with an

    Ezzyrider35 pointsBadges:
  • ora-01033 oracle initialization or shutdown in progress

    ora-01033 oracle initialization or shutdown in progress what is solution

    0801705 pointsBadges:
  • ORA-12541:TNS:No Listener

    When I want to open the global database from 'the Oracle Enterprise Manager Console Standalone' menu in Oracle 9i, then the 'ORA-12541:TNS:No Listener' message occurs. It can't open the database. It also needs the user id & password. What should I do? Moderator Note: This is a submitted question

    BrentSheets6,925 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:
  • ORA-01031 Insufficient privileges

    I am trying to generate FK on table in schema A, which is the reference of PK on another table in schema B. The owner of schema A is also a DBA. It gives an error ORA-01031 Insufficient privillages

    SRDBA5 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 stored procedure error with PL/SQL

    We wrote a stored procedure, where we are passing input as VARCHAR2. And passing 73 characters string as input. Till here its fine. After giving few extra characters above this, it’s giving the error: ORA-06502: PL/SQL: numeric or value error ORA-06512: at "stored procedure name", line 114...

    BrentSheets6,925 pointsBadges:

Browse Alphabetically:

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