• Running Procedures within the PL/SQL program

    WE are dealing with stored procedures in a PL/SQL program. I am trying to execute the procedure from within the program itself. Is there a need to do it within a cursor or is there a specific manner to do that?!

    Nimsalwayz5 pointsBadges:
  • calling reports

    i am trying to call oracle 9i report through 9i forms but getting the error: REP-0503 YOU DID NOT SPECIFY THE NAME OF THE REPORT please help me and tell me the complete steps of calling the report through forms

    Majid5 pointsBadges:
  • connect sys as sysdba

    how to connect sys as sysdba in toad software and in isqlplus. When i tried in isqlplus and in toad by connecting as "sys as sysdba" i got the error. please give me a solution.

    Itsee10 pointsBadges:
  • BLOB Data move from Oracle 9i to Oracle 10g

    I want to move BLOB data from oracle9i to oracle 10g through java application. I am getting following error : java.sql.SQLException: ORA-00942: table or view does not exist. Using JDK1.5 & ojdbc5.jar

    AUpadhyay5 pointsBadges:
  • Calling a report from form

    Hello all We recently have migrated from oracle 6i to 9i DS. We have some forms which are calling a report. I have used the run_report_object() instead of run_product() in 9i. Previously the forms were displaying the reports properly. But I have re-installed the windows and oracle due to some...

    Rakh80 pointsBadges:
  • Options available for implementing external account authentication with Windows AD with Oracle 10.2.0.3 on Linux

    Scenario: Windows desktop user logs in to the Windows domain and is authenticated by Windows Active Directory. The same user then lauches a Citrix session to connect to an application running on a Windows Citrix server and is authenticated using Windows passthrough authentication. The application...

    JPGDBA19685 pointsBadges:
  • Oracle 10g, Export problem through OEM

    Hi, i'm trying to export my database and my user is DBA role user, and it has all the roles other than GLOBAL_AQ_USER_ROLE. After specifying all the parameters when i submit the job, it displays the following error. if i do the same steps with SYS user it works fine. "ORA-20204 usr does not exist:...

    SalmanBaig0 pointsBadges:
  • oar-01033

    ORA-01033 and from I understand from reading posts..i'm to log in as sys/password as sysdba. When I do this, sqlplus is returning the error message: ORA -01031 Insufficient privileges. I've tried several different usernames...but SYS should work as i've used this many many times in the past "as...

    Maitreya5 pointsBadges:
  • About oracle editions

    i would like to install oracle 10g in personal desktop,but i saw in oracle site 10g express edition,standard edition and enterprize edition.what was the differences between them and if i want to install which one better?

    80715 pointsBadges:
  • Subquery?

    I used to think I was good with sql as I have used it for quite a few years with informix, but now I am trying to create an sqlplus with oracle and some things are not working the same. I have 3 tables. customer general customer detail location I have used a join to list all the required customer...

    MizzGail85 pointsBadges:
  • JDE World

    How to write a credit memo. Are they made up of line types and doc types?

    Tjm666610 pointsBadges:
  • i need help urgently

    hello fellow IT friends,i just installed oracle10g on window xp, and i cant seem to open my enterprise manager.am a new user of this software can someone help me?

    Iruedo055 pointsBadges:
  • Truncate or not Truncate SQL

    What are the pros/cons of truncate a table export/import to just drop table?

    Jay Dog5 pointsBadges:
  • ASM State in GMON Trace File

    Oracle 10.2.0.3 RAC using ASM: Red Hat Enterprise 2.6.9.44 (RHEL 4.4) I have having problems bringing up a diskgroup in ASM. When I try to mount it, ASM hangs. When I review the GMON trace file, it shows the diskgroup trying to mount and is says "Member state = 4". What's a member state and what...

    Dwaltr900 pointsBadges:
  • view color codes

    Hello... i m beginner in lotus notes and would like to know how to change/set color code to particular row in the view based on formula or condition...?? For ex. if the column value is vacant i have to set green color for that entire row in the view. if the column value is occupied it should red in...

    NotesBeginner5 pointsBadges:
  • What is the PRAGMA_INIT exception?

    What is the PRAGMA_INIT exception? Thank you.

    OracleATE190 pointsBadges:
  • Running RMAN (Oracle 9.2.0.8 Enterprise Edition) over network fails with ORA-12560

    Running RMAN (Oracle 9.2.0.8 Enterprise Edition) over network fails with ORA-12560 - TNS Protocol Adapter error. In RMAN cmd file I've tried re-directing to OraHome with \dev-oraclec$oracleora92 as well as directly to the mapped drive: Z:oracleora92. Both fail with same error. I also set...

    OracleATE190 pointsBadges:
  • What more do I need to do to get instant client working with IIS?

    I have installed instant client on my XP computer and am able to connect to a remote Oracle 10g server with SQL plus using this string: sqlplus myid/mypassword@//server:port/svc I have also been able to make a DSN file that connects, and have been able to connect with Visual Basic. I HAVE NOT been...

    OracleATE190 pointsBadges:
  • Oracle Application Express Item

    I have two tables with parent-child relationship. Is there a way to automatically populate the foreign key field of the child table with the exact data from the primary key of the parent table?

    Rwy265 pointsBadges:
  • Report not running in web layout for Oracle 9i

    hello we recently have migrated from oracle 6i to oracle 9i. my problem is that when i compile and run a report (that was built in reports 6i) the web layout in reports 9i is not displaying. the paper layout version is working fine but i need a web layout which is not working. its not giving any...

    Rakh80 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.

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

Following