Recent content by Packermann

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

Yes, both the dbms_output print or using exception seems to work.<br><br>Thanks guys <p>Paul<br><a href=mailto:packermann@niku.com>packermann@niku.com</a><br><a href= > </a><br>

Mike,<br><br>You could try to write your own funtion:<br><br>CREATE OR REPLACE MYFUNC (field IN CHAR)<br>RETURN CHAR<br>IS<br>BEGIN<br>DECLARE retval IN CHAR<br>FOR i IN LENGTHB(field)LOOP<br>&nbsp;&nbsp;IF i = 1 THEN<br>&nbsp;&nbsp;&nbsp;&nbsp;SELECT retval + UPPER(SUBSTR(field, i, 1)) INTO...

The exception handling part is fine, but what does not work is <b>SELECT * FROM test_table</b>. This gives an error that you need to use an INTO with a SELECT. And yet the sql statement is perectly valid if not in a procedure. How do I display the contents of a table from within a procedure?

Try running UPDATE STATISTICS on your tables and then re-compile your procedures. <br><br>Also, check the number of indexes on your tables. Try reducing the number by combining some indexes into one. This will reduce the amount of IO your INSERT have to do. This may mean you would have to change...

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

Also, if you do not have to worry about existing data in the target table, try using a SELECT INTO instead of an INSERT SELECT. A SELECT INTO bypasses writing to the transaction log. But this requires that you to first drop the table and let the SELECT INTO re-create the table. It also requires...

It sounds like a Java and some other client language error instead of an SQL error. If that is the case, it may be that the client is not properly displaying the error. Try running the actual SQL statement in Query Analyzer. My guess is that the actual error may be a deadlock or the user not...

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

Yes, I already used sp_addlinkedserver and sp_addsrvrlogin.<br><br>But, I think I solved the problem. I colleague of mine told me that OpenQuery only works on a true 7.0 database. Our database is 7.0 with 6.5 emulation. Since it has 6.5 emulation it does not recognize the OpenQuery statement...

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

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