Recent content by ljspop

What version of developer are you installing? It sounds like an error one would receive when trying to install an 8.0 product on top of an 8.1 product. Unfortunately I don't know if that is possible. The converse is acceptable, just not 8.1 than 8.0, as far as I know. Also, depending on the...

Hi Dzidze - The answer is it depends. Naturally. It sounds like you are new to Oracle8i - and there is a lot to learn. However, how do you like the format of the classes on OLN? Some are much longer than the 5 min one you took, but most are around 15 minutes or so I'd say. There is a lot...

Since you mention FORM_TRIGGER_FAILURE I assume you are refering to Oracle Forms. If you need to raise an application error from a server side trigger use the oracle provided procedure RAISE_APPLICATION_ERROR. If your server side trigger fails, I would assume Forms would fail as well, but this...

Hi, Oracle ODBC Drivers are available at technet: http://technet.oracle.com/software/utilities/software_index.htm That said, I've had good success with the Microsoft supplied drivers in the past. As Karluk said, make sure all of your tnsnames files are properly configured. Good luck! Bob...

Hi - If you use dynamic SQL you can put your SQL in a variable and build the statements that way. That would also allow you to get rid of the decode statement in the where clause. Functions in the where clause really cripple the optimizers ability to do its job. Hope this helps. Bob Bob...

Hi Hoctro, Divide 100MB by your db_block_size and add that to your current value of db_block_buffers. Database buffer cache size is determined by: db_block_size * db_block_buffers = (size of db buffer cache) Bob Bob Lowell ljspop@yahoo.com

Hi John, Try adding a "whenever sqlerror" statement within your sql_script.sql file. The syntax from the 8.1.5 docs is: WHENEVER SQLERROR {EXIT [SUCCESS|FAILURE|WARNING|n|variable|:BindVariable] [COMMIT|ROLLBACK]|CONTINUE [COMMIT|ROLLBACK|NONE]} At least than your $rc can be...

Hi Stressball, As your sys or system user run: alter user stressball quota unlimited on system; the unlimited can be replaced by an integer + K or M to give an actual size quota. One of the first things you'll learn when you get to the administration portion of the OCP is that when you...

Hi, I don't think forms has a built in zip functionality, try looking up the 'host' command in the on-line help. Of course doing this client server will require either all your clients have a standard zip executable, or (if running on Windows) you'll have to look in the registry for how they...

Hi Karluk, Having very little social life lately, and really liking your idea, I gave it a try tonight and found it to work real nicely. I did a 47k long datatype copy and it worked great. A couple of footnotes for your faq - it didn't work for me on long raw data, and folks are better off...

Hi, Karluk is right - you will be wasting space in your indexes as well as having them be inefficient. Also, the high water mark for your table will be way off after a delete of a considerable percentage of your table. That means that full table scans will waste time scanning the empty blocks...

Hi, I think Karluk's solution is going to barf if your long is over 32k. Per the Docs " you cannot retrieve a value longer than 32760 bytes from a LONG column into a LONG variable. " If none of your longs are longer than that you're set. I have used PERL DBI Blob reads to deal with...

Hi, I've read that the sa password is stored in plain text in the registry when entered through Enterprise Manager in SQL Server 7. I tried to simulate this, but could not find a key that had the password I used stored in it. Does anyone know the name of the specific key that stores the...

Hi Mike, If this is an adhoc or report type query (not something in an application everyone is going to be using), you can do an alter session to adjust your sort area size and not affect the amount allocated by default to all other sessions. Just another (hopefully useful) option. Bob Bob...

It also doesn't help to have Ellison slamming Linux at Oracle AppsWorld. http://www.informationweek.com/827/confid.htm (Scan down to the second paragraph) Bob Bob Lowell ljspop@yahoo.com