Either there is a bug on the web site, or I am totally confused on how to download the software. I am trying to download CVS for Windows, and I am going in circles. One link brings me to the next link, then the next link, and then it brings me to the original link again. Other colleagues are...
I need to save a string value to a file. The File Save dialog must first come up so that the user can select where he wants to save it. This needs to be written in Javascript or HTML. Could someone please help me?
Paul
packermann@niku.com
I am having problems inserting into an Oracle table using a linked server.<br><br>The problem is that there columns in the Oracle table that have datatypes that are not supported by Microsoft. Even if the problem column is not specified in the INSERT clause, I still receive an error that the...
I found out that I can call an Oracle procedure from Microsft SQL Server using an OpenQuery function.<br><br>But in order to do this, the Oracle procedure must return a result set. I could not get it to work. I then tried to use a function, which did returned a value, but Oracle would let me put...
I am a novice in Oracle. I need to create a procedure that inserts a value into a table, if the insert is successful, to return all the rows in that table. Particularly I am having trouble determining whether the insert is successful and I cannot use a <b>SELECT</b> without an...
I have two queries:<br><br>1. SELECT *<br>FROM OPENQUERY(CHINIKU01, 'SELECT * FROM nitc_lookup_values') <br><br>2. SELECT *<br>FROM CHINIKU01...nitc_lookup_values<br><br>#1 works fine. But I need to use #2, and #2 used to<br>work on Friday, but now I get the error message:<br><br>"OLE DB...
Why is that I can only get the OPENQUERY to work on the master database?<br><br>SELECT *<br>FROM OPENQUERY(CHINIKU01, 'SELECT resource_id, last_name * FROM LARRY.nitc_cons_workerbee') <br><br><br>On a database other than the master, I get the error message:<br><br>"'CHINIKU01' is not a...
I am able to do a query, but nothing else.<br><br>Here is my statement that works:<br><br>SELECT *<br>FROM OPENQUERY(CHINIKU01, 'SELECT CODE FROM LARRY.nitc_lookup_values') <br><br>This works fine. But how can I update the remote table, or insert into another table that resides on the Oracle...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.