Never underestimate the power of Google. I did a search on ‘java rfc sap’ and found this: http://help.sap.com/saphelp_46c/helpdata/de/8c/20e8e9493311d1894a0000e829fbbd/content.htm Please do some more research based on the keywords found in this page. I know Java but not SAP so I can’t go deeper on this question.
View Answer | January 13, 2005 9:38 AM
Development, Lifecycle development, Oracle
There are a lot of factors in your dilemna. I have installed a wireless infrastructure 802.11 super g, for a 60,000 sq foot facility. which required two repeaters and three access points, some electrical runs and a couple of days to configure. The facility had several internal concrete structures and firewalls. The cost for equipment [...]
View Answer | December 30, 2004 9:42 AM
802.11 networking equipment, Data analysis, ERP, Human resource applications, Networking, Training, Wireless standards
The resolution to this issue was to use 2 listeners (8i,9i)using 2 different ports. This allowed each version of extproc to find the corresponding executables. Here is a sample of the listener.ora for 9i; 8i listener.ora is the same except for the ENVS clause and the extproc executables defined. A tnsnames.ora file is also needed. [...]
View Answer | December 28, 2004 9:48 AM
Aghhhhhhh. You said the D word. If and when possible you should avoid using the delete function. Try to create a field to mark the records you do not think you need (you may need them again) and redesign your views and stored procs to filter out the marked records. But in all seriousness try [...]
View Answer | December 21, 2004 5:02 PM
Database, DB2, Implementation, Oracle, SQL, SQL Server, T-SQL, Tech support
I am not able to run this but purely looking at the syntax it may be as simple as requiring a ‘;’ after your final FETCH statement.
View Answer | December 17, 2004 6:11 AM
Application software, Availability, DB2 Everyplace, Development, IBM, Instant Messaging, Java, Migration, Modeling, Normalization, Performance/Tuning, Servers, WebSphere Studio
We migrated 4 servers running Windows Oracle databases to one Linux server (Dell Poweredge with external Scsi). The advantage to us is Redhat AS Linux is able to address the 8+ Gig of RAM for Oracle vs only 2 Gig for Windows standard server. The Enterprise CPU licenses we freed from the Windows servers are [...]
View Answer | November 9, 2012 1:51 PM
CIO, Hardware, Linux, Oracle, Oracle 9i, Windows
I haven’t done sql for a while but i think that maybe you can try : insert into tblsap_history ( select * from tblsap ts where ( (ts.css_database,ts.sap) in ( select SUBSTR(source_account, 1, 2),SUBSTR(source_account, 3, 18) from ds_account a where a.source_system = 1 and ts.taig=’ISY002′ and (sysdate-required_by) >= 180 ) or (ts.css_database,ts.sap) not in ( [...]
View Answer | December 13, 2004 7:14 AM
When you connect to the Oracle DB, you supply a userid and pwd. this is the user that is authenticated by Oracle and access privleges checked. If you are using a generic userid, then you have chosen to bypass Oracle security.
View Answer | November 26, 2004 11:09 AM
I have seen this error when your session times out. Check your session/user settings. Stefan
View Answer | November 24, 2004 8:13 AM
Oracle, Oracle 8i, Oracle 9i, SQL, Standard Edition
Have you tried doing an Explain Plan on your query?
View Answer | November 18, 2004 10:04 PM
Development, Oracle, SQL
I assume the connections are straight SQL*NET. If so, each desktop would have its own tnsnames.ora file. At a minimum, these would have to be updated to be made aware of the new instance. The last couple of places I worked had a PC support team with software that could push a new tnsnames.ora to [...]
View Answer | November 11, 2004 6:42 PM
Oracle, Oracle 9i
Altova XMLSpy 2005 is one of the latest jsp editors. IT has intellisense for quick coding and can also handle xml, xslt, etc.
View Answer | November 5, 2004 5:38 PM
I found a solution now: The way to go is as I thought to use a OracleDataAdapter, then filling a DataSet und using this DataSet to Update a SQLAdapter. But this only works if you set the property AcceptChangesDuringFill = false from the OracleDataAdapter !!
View Answer | October 21, 2004 1:24 AM
C, Oracle, SQL
Hate to pass out the RTFM message, but a good read of the upgrade manual will answer all of those questions. But generally speaking what your suggesting is absolutely doable and a good idea. The upgrade process for one database can take a significant amount of time, on the order of an hour or more [...]
View Answer | October 19, 2004 10:56 AM
Oracle, Oracle 9i
Pretty broad question, but for installation issues with Oracle on Linux, I have found this site very helpful if used with the installation notes as well as some the documents available on Metalink. Good Luck http://www.puschitz.com/OracleOnLinux.shtml
View Answer | October 15, 2004 10:15 AM
Administration, AMD PC hardware, Data warehousing/Business intelligence, Database Management Systems, DB2, Development, Hardware, Implementation, Installation/Upgrade, MySQL, Operating system platforms, Oracle, Oracle 8i, Oracle 9i, OS/390, Performance/Tuning, PostgreSQL, Security products, Servers, SQL, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Standard Edition, Standard One Edition, Storage, Storage management, Tech support, UDB for mainframe, Unisys, z/OS
Sorry this is a late response but the major differences will be in the datatypes used and some of the objects such as sequences. This I learnt from going between Informix and oracle.
View Answer | October 13, 2004 5:39 AM
Database Management Systems, DB2, Oracle
What Oracle version you are using and on what platform/OS?
View Answer | October 7, 2004 10:52 PM
DataCenter, Development, Oracle, Storage, Tech support
I am in the process of doing a similar thing. Installing Oracle EE 220.127.116.11.0 on Win 2003. The box is 64 bit but the op system is 32 bit. So I am installing the 32 bit version of Oracle. In order to do this the recomendation was to add a patch to the Oracle Installation [...]
View Answer | September 27, 2004 5:57 AM
Database Management Systems, Hardware, Intel PC hardware, Intel servers, Java, Microsoft Windows, Oracle, Standard Edition, Tech support, Windows on Intel, Windows Server 2003
You GCC version is quite old; looks like the oracle library’s been compiled for 64-bit memory addresses. Perhaps your code isn’t compiled that way, which would explain the link problems. Try recompiling you code. Otherwise, I recommend consulting minimum requirements for gcc. It’s up to 3.3 or higher these days.
View Answer | September 24, 2004 5:55 AM
C, Oracle, Oracle 9i
Hello there, I am a DBA originally started with Oracle 5 and have 13 years of experience using Oracle database. For last five years, I have also been using and administring SQL Server. In my opinion both have pluses an minuses of their own. Here is the comparison between the two based on features you [...]
View Answer | September 2, 2004 11:49 AM
Oracle, SQL Server