Search results for query: *

Hi, This is my problem: i have a source table that have 3 fields: id, column_name, column_value. The problem is that i have to do, using OWB, an update of a target table with the information of my source table. In pl/sql it would be easy to do an update of a variable field but how can i map...

I just can't .. the DBA's don't want. And anyway, i've tried this way, but i can't do an EXECUTE statement in a plsql procedure.. so i think that i will return to school and do haircuts rest of my life.. ;).. joking.. I'll try to find another way, i think its impossible to do it this way..

Hi, Ihave to execute packages, their names are in an Oracle table, and they are in three different schemas. So, in my table, i have the name of the owner (schema), the password and the name of the package. If i am not in this schema, i have to connect to it..

Hi! I need to change user during a procedure. I tried this way: FOR I IN EXECUTIONS.FIRST .. EXECUTIONS.LAST LOOP IF UPPER(EXECUTIONS(I).EX_COMPTE) <> UPPER(COMPTE_COUR) OR COMPTE_COUR IS NULL THEN REQ_EXEC := 'CONNECT :1/:2@UNIF'; EXECUTE IMMEDIATE REQ_EXEC...

Yes.. that's what i did, but i was wondering if we can use the DISTINCT command in OWB.. i guess we can't !!

Hi, Do somebody knows how to do a SELECT COUNT (DISTINCT field1||field2) in OWB? In my mapping, i have an aggregate that makes a 'GROUP BY' and four 'SUM', and in the expression field OWB doesn't give me the 'DISTINCT' option (I have to make a COUNT of distinct NAS). My superior don't want me...

Hi, Can somebody tell me what is the difference between INSERT/UPDATE and UPDATE/INSERT ? Another question: why, when i do an update/insert or insert/update, OWB give me an error 'constraint key violated' when a row in the target table needs to be update 2 times or more? (2 rows with the key...

Opus! I forgot to tell, i am using Oracle Warehouse Builder..

Hi, I wonder if somebody have a tip for this problem.. I have to link a field of my source table in another field of a temporary table, but the source table have over 200 fields and i can't scroll down enough to catch it in the mapping...

Hey WOW !! You Really gave me an idea, you genius!! Thanks a lot, for taken the time to reply to my question.. (And excuse my english.. :) )

Hi all! I have this problem using Oracle Warehouse Builder: In my source table, i have this key: No_usag, typ_sdu and seq_sdu. This is call a 'SDU'. In my target table, i want more than one record by SDU, per example: SDU NAS FEF CA 1111111111TQ0001...