• How to capture error stack when using forall in PL/SQL?

    How do you capture all the errors in an error stack when using forall/bulk processing within PL/SQL? This is the error stack: ORA-12801: error signaled in parallel query server P000 ORA-01722: invalid number The only error captured in PL/SQL is the first error message but the second is actually...

    Rb plsql0 pointsBadges:
  • XML Publisher with Shipping Docs

    We are trying to use rtf Templates for our shipping docs. When we launch the concurrent request individually they work great. But when we use Ship confirm (which launches the doc set automatically) the xml is generated but the pdf format is not. Looking at the submitted requests, the layout has not...

    Dmcdconsult40 pointsBadges:
  • Query SYSTEM tablespace Privileges

    I am trying to figure out what privileges two users have to the SYSTEM tablespace... However quering the "user_sys_pivs" table will only give me the privs of the user I am logged onto the system with. Is there anyway I can find out that information without logging to their account. I am using orcl...

    Ragheed0 pointsBadges:
  • oracle quires

    while executing the following qurie 'inser into custmaster select * from tnjcust where seccode='431';' answer is not enough valus

    Balachander k0 pointsBadges:
  • Oracle 10g Data Pump export through EM DB control

    When I am going to use Oracle 10g data pump export, after entering of OS user name and password and do OK, it is giving me "RemoteException Error: wrong password for the user" why this error is coming pl. give me any solution thank you

    Sr123470 pointsBadges:
  • Data Sync in tow tables

    We are in the progress of restructing the old database. In this effort , we are joining data from 3 files files and creating a new schema. in the process of migration , we need to keep the new file and the old files in sync. How do we achive this? I was planning for triggers on Old file and the New...

    Uiiuo50 pointsBadges:
  • extract whole schema’s package hit problem.

    i need to extract the whole APPS schema packages spec and body, the problem is, there got nearly thousands of packages..it will make the my toad hung or use up all my pc memory; i can't do it with export becoz the users need it in readable format. do u hv any idea? hope somebody may help, or reply...

    Rain5forest0 pointsBadges:
  • hash Bucket–hash Partititioning

    What is the hash bucket /hash function in hash partitioning and how can we set the value for hash bucket.Could you please give me brief idea abt this?

    SatyaDBA0 pointsBadges:
  • iSupplier

    Anyone know anything about iSupplier and its relationship to ASCP?

    BarbJH0 pointsBadges:
  • Help! Does anyone know if this is true?

    Hi. The City of Atlanta is switching over to Oracle 10i. The city intends to move from 6 pay schedules to 1 pay schedule. There are 350 employees out of 9000 who would like to remain on their current pay schedule. The City claims in order to add this to the Oracle that is being installed it woudl...

    Opal0 pointsBadges:

    We are using Oralce E businees suite and the notification mgmt requires you use imap4. we are in a exchange 2003 clustered environment. what are the risk in running this service for one application to send notifications?

    Shelly990 pointsBadges:
  • SQL joins on encrypted data

    Hi - we are in the process of encrypting various pieces of sensitive information in our SQL 2000 tables. For many fields we are using Blowfish 448 encryption and a concern has arisen about inline SQL statements that contain joins in our ASP scripts. Are there any scenarios that you have run across...

    Tombstone7770 pointsBadges:
  • Tracing on Oracle 10

    Hi, In order to get tracing info on Oracle 9 I added the following to the SQLNET.ORA TRACE_UNIQUE_CLIENT=on TRACE_LEVEL_CLIENT = 16 TRACE_DIRECTORY_CLIENT = C:\Oracle10Run TRACE_FILE_CLIENT = SQLNetTrace TRACE_TIMESTAMP_CLIENT = ON This worked fine and generated the relevant trace files. When I...

    Eg0 pointsBadges:
  • i want to get updated or deleted or inserted views from last four days

    sir, How can we find views which are got manipulated(DML) from last four days or one week.

    Maneswar15 pointsBadges:
  • Dell Laptop NIC not showing up

    I hace had to wipe and reload windows XP pro on a school Dell Latitude d510. After, the default NIC doesn't show up in network connections, only the firewire adapter. After installing drivers from Dell, the wireless NIC shows up. I can't find any drivers from Dell for the NIC and I don't know why...

    HornetITguy0 pointsBadges:
  • Standard Oracle Login and Password for “ADP PC Payroll For Windows”

    Hi, I am mirgrating an old ADP Oracle system, and the new DBA does not know the Oracle login and password to the ADP system. Has anyone worked with this system, and do you know the stanadrd Oracle login and password to this ADP version? ADP has not been helpful since the customer left them (but the...

    Twincalicos0 pointsBadges:
  • Oracle Question

    I have just started working with a client who has had a large database application written in oracle. The application has been mirrored onto a training server with a small amount of data. I would like to create 4 different training databases on the same server (after a server upgrade) with a...

    Chrisgee0 pointsBadges:
  • odbc access error…….

    Hi, a company send their information for us,it was a zip file that contains a ms access database file and a simple exe file,when I have administrative right on computer when I run exe file,a form was opend and I can see data,but when a power user open it an error was appear :...

    Aliyani265 pointsBadges:
  • Find student whose attendence is less than 75%

    Find student whose attendence is less than 75% in subject AC? select k.studentID, k.PercentageAttd from ( select a.STUDENTNO as studentID, (select count(PRESENCE_K)*100 from attendence b1 where b1.PRESENCE_K='P' and STUDENTNO=a.STUDENTNO and subject_k = 'AC')/ (select count(PRESENCE_K) from...

    NavinT0 pointsBadges:
  • SQL behaves differently in two identical Oracle 10g db’s

    I have a SQL statement that is behaving differently in two "equal" databases (equal in schema, but size differs by about 50%). Here's the statement: select distinct 99, 31, b.school_id, a.provider_id, a.student_id, '2007', lpad('01',2,'0'), '0' from studprovider a, student b, school c where...

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