Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Packermann
  • Content: Threads
  • Order by date
  1. Packermann

    Downloading CVS software

    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...
  2. Packermann

    Saving a string to a file

    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
  3. Packermann

    Inserting data into an Oracle table

    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...
  4. Packermann

    How to produce a result set in a procedure

    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...
  5. Packermann

    Creating a simple procedure in Oracle

    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...
  6. Packermann

    Querying on a linked server

    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>&quot;OLE DB...
  7. Packermann

    OPENQUERY

    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>&quot;'CHINIKU01' is not a...
  8. Packermann

    Updating And Inserting data in a Oracle table from Microsft SQLServer

    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...

Part and Inventory Search

Back
Top