Search results for query: *

Hi, We recently upgraded to Oracle 10.2.0.2 from Oracle 9.2. Our OS is: Unix AIX After the upgrade we are facing a strange problem with our sql loader. We load several flat files everyday one after the other into our flat tables using sql loader. After the upgrade, the sql loader hangs...

Hi, I have the following queries in a procedure and the performance is very bad. I need help in combining these two queries. 1) this is the cursor SELECT --+FIRST_ROWS DISTINCT a.cable_num, b.pair_num FROM tab1 a, tab2 b, tab3 c WHERE a.col1 = b.col1 AND b.col1 = c.col1 AND a.col2 = c.col2...

Hi, I am new to BO. I am trying to create a universe using BO designer. I am able to see the oracle table columns when I add them to universe. However when I add a remote table (synonym), I am not able to see its columns. I am able to create the class for that table, but again while trying to...

Strange SQL Loader problem. We are encountering a strange SQL Loader problem. Here are the details. We are using the following oracle version. Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production OS - Unix IBM AIX The sqlldr is invoked from within a Unix shell script using...

We have lots of Shell scripts where the password is hardcoded to connect to the database(Oracle): Ex: sqlplus username/password The password should not be in clear text & should be encrypted before connecting to the backend. Oracle will not take encrypted passwords in my opinion to connect to...

I am trying to use a procedure call in an update query, But it is not working. The main procedure is not getting compiled. I am on oracle 9i. The statement is UPDATE --+INDEX(BPT_TO_DLM BPT_TO_DLM_INDEX) bpt_to_dlm SET rmt_trml_ind = NULL, rmt_trml_avail_ind = NULL, rmt_trml_clli_cd = NULL...

Hi, The following query works fine in SQL Server and I would like to achieve the same in Oracle 9i. It does not work in Oracle. Can any one help who knows the equivalent of this in Oracle ? UPDATE WEB_FSP_DATA a, WEB_DA_CERTIFICATION b SET a.address_qualified_date = SYSDATE, a.da_completed_id...

Hi Gurus, I found that whenever my procedure is called, it is precompiled. Is there any way I can tell SQL Server not to precompile a particular stored procedure ? I appreciate your responses. thanx.. -Bheemsen

Hi, I am using temp table in my stored procedure. The temp table is first created and rows are inserted. Then I am selecting data from same temp table. Everything is inside the stored procedure. This stored procedure is called from a Java (EJB) program with at least 100 threads at the same...

Hi All, I am using the following control file to load data into an oracle table (version 8.1.4). LOAD DATA APPEND INTO TABLE FF_DA_TAPER_TERM FIELDS TERMINATED BY '|' TRAILING NULLCOLS ( WIRE_CNTR_CD, WIRE_CNTR_NAME, TAPER_CD "SUBSTR(:taper_cd,1,6)", SERVING_TRML_NAME...

Hi, Does any one see any improvements that can be made to the following queries. They are taking a long time. Query #1: SELECT a.wire_center, a.wire_center_name, a.terminal_name, street_num, street_name, unit, floor, building, a.id, living_unit_id, community, state_cd FROM...

Hi Guys, Does any know whether it is possible to create one trigger on multiple tables. What I mean to say is : Assume ther are 3 tables X, Y, Z. I want to insert a row into the table A for any UPDATE, INSERT or DELETE action on any of the X, Y, Z tables. I want to accomplish the above using...

Can I pass a cursor variable to a Oracle stored procedure from the host environment ? We are using JDBC to call the stored procedures. Our environment is Unix(AIX), Oracle 8.1.7, Java and JDBC. the host environment is Java. The database server and host environment server are not the same. I need...

Hi, I have a following cursor coded in a stored procedure. This part of the procedure is taking long hours to complete. DECLARE FF_LU_WTN_STAGE_LU_ADDRESS_DIFF_CURSOR CURSOR LOCAL FAST_FORWARD FOR SELECT wire_cntr_name, living_unit_id, wtn, id FROM ff_lu_wtn Where wire_cntr_id =...