Visit Experts Exchange from your mobile device to search, ask, and monitor your questions. Never lose touch again.

Preview From Your Desktop
 

Having problems asking a question? Have a general question about Experts Exchange? Let us know!

 
Time Tested Oracle 3rd Party Tools Solutions: 101 - 125 of 402
 
I had to modify a database table by adding a few fields.  There existed an Oracle Forms data block based on the table before the changes had been made.  Can I refresh the block so that it reco...
I am trying to set up Explain plan tables in Toad. When I run the Toadprep.sql script in Toad's sql editor, it comes with dialog box asking me to enter the values for, 1) :USERS 2) :INDX ...
Hey, I have created a connection to oracle db in ASP session now I'm trying to use savepoint and rollback. The savepoint ("savepoint sp1") doesn't return an error but when I try to rollba...
I have a separate form with a parameter.  This parameter gets populated by the calling form with a string which is basically the FROM and WHERE clause of a select statement I'm dynamically bui...
I have tried a lot to fix this, but not much has seemed to work. I am working with TOAD on an Oracle database server. I believe it is version 8 or 9. My freeware version of TOAD expired. I was...
Silly question but since I can't read the font I have to ask!  Can anyone tell me how to change the font used for Comments in TOAD (v 7.6)?
HI, I want to upload data from .xls file to a database table.  I am using Oracle 8i. The .xls file is in Office 2000 format.   What are the different ways of uploading the file.  I kn...
I get that error when I try to insert a record. I didn't get that error before, as one of a sudden it started popping up. I searched the net, and I found no answer. Except that I heard t...
Hi, First I got the ORA-01578 data block corrupted on file #3, block #4159 error message.  Then, I found out that corruption is on the rollback segment RB3.  I took the RB3 offline.  I trie...
I've got a query string, such as 'select * from TABLENAME', or a 'select a.* from TableA a, TableB b where a.id = b.id'. If I create a Record Group based on that query string, is there a way ...
Whenever a constraint is violated inserting records thru a Form developed with Forms 6i,  DBMS_ERROR_CODE  reports error 1403 (NO DATA FOUND) instead of ORA-00001. If you go to Help --> Er...
Hi, I wouldl ike to use Oracel SQL Developer and setup a Job / Task  and schedule it to run a SQL script. Does Oracle SQL Developer allow this or must a use something else? (like Toad)? W...
Hi expert, I have a database on an Oracle 8 server.  Now I want to do a BASIC request using Oracle SQL*Plus Version 8.0.5.0.0 on my PC (Win2K).  Here the query: SELECT FP.EMPL_EXPERIENCE...
i am getting the following error FRM-18108 : Failed to load the following objects , source module: ***.olb source objects :** source module ****.olb source objects many times i...
Hi all I have a cursor that retrieves data.  However when an exception occures e.g. WHEN NO DATA FOUND  the script will stop or if there is a problem with the current line of data it will ...
Hi experts, I installed the WebUtil package provided from oracle. What I did is: declare v_filename varchar2(100); in_file Client_Text_IO.FILE_TYPE; Begin  v_filename := 'C:\GRF\cds....
Hi there, I am looking for the Hyperion System 9 Security Guide. This should be a PDF that is availiable to download. Any help will be greatly appreciated. Thanks !
some tips: ok a remark is marked as --debugging where i think the problem is working on hpux oracle 7  apps 10  SC RUNNING FROM WIN XP (i dont know if this has any problem     to use ...
I WORK TO DO NEXT IN A ORACLE 8.1.6 RELEASE RUNNING IN HP-UX VIA SQLPLUS: ALTER USER COON0MTR IDENTIFIED BY PRUEBA; AND THE SYSTEMS ANSWERS: alter user coon0mtr identified by prueba * ...
Hi Experts, I wrote this code in Developer 10g to call a report in the trigger when-button-pressed declare      rep_command    varchar2(1000);      repid REPORT_OBJECT;      v_rep VARCHAR2(100);...
Hi, I need to do the following query in hibernate. What is the best way to do this? We have a theater object mapped to Theater.hbml.xml. SELECT * FROM   (   SELECT *            -- A...
where is the registry UI_ICON and how do i set it up
Hi I'm trying to write a report that has an outer join to a constant.  I have the following SQL: SELECT ....... FROM   ........      WHERE ext_trad_ref.cmpy_num(+) = trade.cmpy_num     ...
Hi Experts, I have a number of SSIS packages for SQL 2005 and now the source is moving from SQL Server 2005 to Orcale.  I have a VPN Tunnel to the new Orqcle server  have connected to the Ser...
(p_username IN dba_role_privs.grantee%TYPE, p_role OUT dba_role_privs.granted_role%TYPE) IS v_username dba_role_privs.grantee%TYPE; v_role dba_role_privs.granted_role%TYPE; BEGIN SELECT...