Recent content by ruse7013

Hello, What is the proper way to check for the number of command line parameters in Windows? In Unix there is something like: # If the number of command-line parameters # is not 10, then do something. if [[ $# -ne 10 ]] then ... fi How do we "translate" that into a Windows batch file code...

Hi sem, Unfortunately, I'm under the gun to finish this task and don't have time to publish what you've asked me. The key here is - how we update the records in tab_A - one at a time or many at a time. Your idea is great, no doubt about that! Throughout the course of this discussion, both...

Hi sem, Thank you for your idea. I tried it. The elapsed time does not look very promising - close to 10 minutes compared to my best of 224 seconds. I need to take another avenue. Thanks. Regards, <ruse7013>

Hi sem, Yes, that's what my challenge is. If you take a look at my original message, it's all said there. Thanks, <ruse7013>

Hi sem, In your suggestion above: UPDATE tab_A SET c1 = f1(c1,c2,c3), c2 = f2(c1,c2,c3), c3 = f3(c1,c2,c3) where is the "WHERE" clause? I guess, there should be one. Otherwise, how do we know that the update is done for a specific group of c1,c2,c3? In other words: UPDATE tab_A SET...

Hi sem, The value conversion doesn't take too much time. So, I'll test your idea and see what happens. BTW, what's RBS? Thanks, <ruse7013>

Hi sem, Please take a look at: ... processing of c1,c2,c3 ... getting new values of c1,c2,c3 c1,c2, and c3 are interdependent. A function is called w/ the old values as IN params. For every cursor iteration, ALL three old values are taken into account in order to determine what the...

Hi Himanshu, I've done it. It didn't improve the elapsed time too much. However, I had a challenge of declaring the type of the bulk collection that would keep the ROWID values. Is this correct: TYPE typ_Rowid IS VARRAY(1000) OF VARCHAR2(50); I tried: TYPE typ_Rowid IS VARRAY(1000) OF...

Environment: Oracle 8i (8.1.7) Scenario: Three columns are retrieved - CURSOR cur_name IS SELECT c1, c2, c3 FROM tab_A; Let's say the original retrieved values are equal to: c1=old_value1, c2=old_value2, c3=old_value3 Some processing take place and we find new values of c1, c2, and c3...

Hello Himanshu, Actually, I found the init.ora as initSID.ora. However, I wouldn't be able to open it due to unsufficient access permissions. Also, I found this: "Consider increasing the value of the DISTRIBUTED_TRANSACTIONS when an instance regularly participates in numerous distributed...

Hello Himanshu, I found file init.ora in $ORACLE_HOME/dbs However, there is not a parameter called distributed_transactions in file init.ora What can I advice my DBA as fas as setting that parameter? What's the best (or safe) value? Thank you. <ruse7013>

Hello, Environment: Oracle8i Scenario: A package/procedure is executed under object owner "A" in db_schema "A". A cursor is retrieving records from a table "B1" from db_schema "B" (via a db_link!) using BULK COLLECT. Ultimately, all the records are INSERTed (via a db_link!) with FORALL INTO...

Sposibo, Dima! Regards, <ruse7013>

Hi Himanshu, You are right. I found the problem in the foo() function. It's related to: SELECT SYSDATE FROM DUAL; TWO records are returned instead of ONE: 5/5/2004 12:45:36 PM 5/5/2004 12:45:36 PM How can you explain that? I added: SELECT SYSDATE FROM DUAL WHERE ROWNUM = 1; ... but I...

Env: Oracle 8.1.7 The following procedure is executed: -------------------------------------- PROCEDURE proc_name AS CURSOR cur_name IS SELECT col1, col2, rowid FROM table_name; BEGIN FOR rec_name IN cur_name LOOP BEGIN v_var3 := foo(rec_name.col1, rec_name.col2)...