IT Answers » Interaction Center Technology Sat, 15 Mar 2014 10:09:47 +0000 en-US hourly 1 Using Query returned values in Oracle Graphics 6i Wed, 23 Nov 2005 07:08:55 +0000 Hi all,
I wrote a query in Oracle Graphics Builder (6i)(Bar Graph). The query will return diff. categories(so multiple bars) wherein each category will contain atleast one subcategory(Maximum three). So, each bar will contain either one or all the three sub-categories. My requierement is to set the colors dynamically to the sub-categories based on the return values. I mean especially the colors of “WALL”s and “TOP”s of the Bar Graph should change dynamically when there are one or two colors.
Can anybody explain me how to acheive this?

Thank u,

]]> 0
Direct insert into a remote Oracle RDBMS (not running SAP) from SAP. Can it be done from SAP? Thu, 28 Apr 2005 14:55:51 +0000 We need to insert SAP data directly into a staging table in a non-SAP app on a remote Oracle 9.2 DB. We’ve been given write access to only this one table in the remote Oracle DB.
Currently, we create a flat file in SAP (on a DB400 DB), FTP the file to an intermediate Oracle DB owned by our group, SQL*Loader it into our Oracle DB, then use Oracle’s database link technology to insert into the table in the target remote Oracle DB.
Can we write to this table directly from SAP? How do we do it (Function module, BAPI, native SQL, or what)? Thanks!

]]> 2