• Error when translating execute immediate from Oracle to SQL

    SSMA warning messages: * O2SS0356: Conversion from NUMBER datatype can cause data loss. BEGIN FETCH emp INTO @emps$emp_name, @emps$emp_id IF @@FETCH_STATUS = -1 BREAK IF @emps$emp_name = 'Avi' /* * SSMA error messages: * O2SS0013: EXECUTE IMMEDIATE statement was converted into EXEC(...) statement,...

    Ariel5 pointsBadges:
  • PA: Error in main

    What does this mean?

    Ruthkowalski5 pointsBadges:
  • Oracle data missing, over 500GB worth.

    Instance of Oracle on HP-UX 11.11, Oracle version 9.2.0.8, has lost hundreds of GB of data. Manual/accidental deletion is not possible as the process would take a long time to execute. Error logs do not show much, AUD$ log doesn't show any user activity during the window of time (roughly 24 hours)....

    Spamtrap15 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:
  • procedure create with compilation error ora-6550

    i created table staff with two column a number(3),b number(3) then created procedure p1 but it shows error as procedure created with compilation error & during insert ORA-6550 error at line 1 column 7 create table staff(fno number(3),lno number(3)); create or replace procedure p1 (a in number,b in...

    Yagnesh5 pointsBadges:
  • ERROR MSG DURING ORACLE FORMS INSTALLATION

    ERROR IS USER1.PIN(20) OS_ERROR WHILE SPAWNING...IFSRV60 -INSTALL FORMS60SERVER-DEFAULT...PORT=900 MODE=socket batch+yes  

    Cynthiajiles5 pointsBadges:
  • error in alert.log in oracle 10.2.0.3

    ERROR IN KQLMBIVG SEE LCK TRACE FILE ---error is there in alert.log file

    Chiya12335 pointsBadges:
  • Oracle error: PLS-001003

    PLS-00103: Encountered the symbol "PROCEDURE" when expecting one of the following: end not pragma final instantiable order overriding static member constructor map The symbol "static" was substituted for "PROCEDURE" to continue.

    Citoracleclass20 pointsBadges:
  • Database auditing

    Hi everybody? I do have a shema named PRACTICE with its own table named EMPLOYEES. The table has fields: empid,fname,sex and age. Their data types are varchar2,varchar2,varchar2 and number respectively. The fields also held values LA,Lensa,F and 21 respectively. Being on the sys schema, I defined a...

    Girma30 pointsBadges:
  • db_link in Oracle 9i

    Why I solve this problem?This error is 'ORA-06401: NETCMN:Invalid Driver Designator.'The error occurs when I am trying to insert record through database link.

    Akbarmscjnu20 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:
  • Oracle 10g Unable to connect the Report server

    Im using forms 10g and reports , i have deployed forms and reports in internet explorer, im able to open the forms from the menu, but Reports its shoing unable to connect, i have created batch file for report to start automatically, still it is not connecting, im getting the same error, i guess i...

    ITKE351,865 pointsBadges:
  • Oracle 8i connection error

    Hi I installed windows 7 in one pc and i want to install oracle 8i client on that pc (we need to access crystal report from oracle 8i database) but windows 7 is not support oracle 8i client so i  want to configure oracle 8i database in oracle 10 g client. I tried to configure oracle 8i in oracle...

    Dijeshvj15 pointsBadges:
  • ORA-00257

    What's the quickest way to resolve an ORA-00257 error? What are some ways to prevent this from happening?

    Sanders635 pointsBadges:
  • ora-06544

    while calling report from form ora-06544 error is occured

    Pervez5 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:
  • Oracle 10G installation errors on memory variable

    WHEN I INSTALL ORACLE 10G FIRST TWO THREE TIMES INSTALLED PROPERLY.AFTER DELETING ALL THIRD TIME AFTER INSTALLING DEVELOPER SUIT I DELETED 10G AND INSTALLED AGAIN.AT THAT TIME ENVIRONMENT VARIABLE 1036 ERROR MESSAGE CAME .   HOW TO OVERCOME THIS ERROR  

    PAPA1015 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:
  • ORA-02019: Connection description for remote database not found

    I had 7 databases in production environment. I wanted to create a testing environment but I only wanted 2 databases in that so I took the cold back up of two databases and did the cloning. Now my application is able to connect to the database but I am getting an error on some of the operations...

    ITKE351,865 pointsBadges:

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