Search results for query: *

Hello all, I have a relational table (oracle), and the data in it has to be moved to an xml target. I can import the xml target and see parent child relationships, however I am not able to see the parent key and child key in the target when I use it in the mapping desinger. In the mapping...

Hello all, I am trying to query against a tale that has many (hundreds) of partitions (Oracle 9i). The usual way to query against a table with partitions is usually: select * from table1 partition part_one; But, I need to query the hundreds of partitions, around 50 at a time. Is there...

Hello Elbert, I did write procedures inside the package, and it runs fine from TOAD. But now, I am not able to run it from sqlplus. I have no idea why. I am trying to run the package through a shell script and am referencing the procedures correctly, but it's giving many errors. I tried to...

Hello everyone, I need to create a package which will run five different sql scripts. There are no procedures or functions. Currently we run each sql script one by one, through a main sql script. But there is no way to insert any dbms_output, straight to sqlplus. My main need right now...

Hello everyone, We are trying to install 7.2 in our company and we have series 7 running already. We want to keep our existing architecture, but install 7.2 for testing purposes. If I install the 7.2 on one machine (both web services and applications), will it be possible for me to change it...

Hello everyone, I am trying to incorporate the use of the Cognos Query tool in my projects--but I don't know where to start. I know that Cognos Query is installed on the Server, but don't know where to go from there. I have tried to read the Cognos documentation and went to knowledgebase, but...

Hello everyone, I originally had a view T1 which had 5 columns. I altered the view, re-compiled it to have 8 columns. When queried, the view returns the appropriate results on Toad. However, I tried to insert the 3 new columns into a report and I get the following error: DMS-E-RBI_QCOLUMN...

Thank you Dave.

Hello everyone, I am facing the following problem: I added a drill through from one report to another report within the same catalog using a column that appears on both reports. BUT, when I click on 'drill down' to the second report I am getting the following error: "Impromptu could not...

Hello everyone, I have used prompts in reports before but with only one entry per prompt. For example, there is a prompt which asks for one account number. However, I want to create a prompt which will accept multiple account numbers and give back all the information pertaining to the...