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