Search results for query: *

I'm trying to write a stored procedure that will loop through a schema looking for a string. I need it to search all tables and all columns. I'm able to get the list of all of the tables and columns to search and then populate a temp table with them. I can't get the syntax correct for...

I've got a bunch of Sun Servers (6800's, 6900's) running Solaris 9 that I'd like to turn into Virtual Servers. In other words, make one of my 16 processor 6800's into half a dozen Linux Servers. I'm having problems finding a virtual server product that can use Solaris as the host os. I've looked...

That seems to have fixed the problem. Thanks for the help. InsaneProgrammer.com

I'm writing a procedure to rebuild indexes from one tablespace to another. The procedure compiles fine but when I run it I get the following error: HDEV8> exec rebuild_indexes('PSINDEX','PSINDEX1','N','N'); BEGIN rebuild_indexes('PSINDEX','PSINDEX1','N','N'); END; * ERROR at line 1...

I'm inheriting a new project that uses Oracle 10g Lite to synch up with a larger Oracle 9i Database. The application is using the OC4J that comes with Lite instead of a an Oracle Application Server. My understanding is that the OC4J should only be used for development and testing. Has anyone...

I looked at that post prior to posting this one but didn't find it helpful. Thanks though. InsaneProgrammer.com

I'm trying to use the code below to send an email from my vb application. I get the following error: Run-time error '429': ActiveX component can't create object The error occurs on the .Send command. I'm trying to do this on Windows 2000 Professional. I registered cdonts.dll. Do I need to...

tarzzy, I have not solved the problem yet. Good luck. InsaneProgrammer.com

I believe that I've found the problem. I think that the permissions on the folder I'm trying to upload to are incorrect. Thanks for the help. InsaneProgrammer.com

Error_Reporting = 2047. Is that strange? Should it be yes/no? I added error_reporting(E_ALL); but nothing changed. InsaneProgrammer.com

safe_mode is off. I will try the fopen() suggestion. I'm use to using IIS and ASP. On a windows box you can just right click on the directory, select properties, and then security to see permissions. Isn't there a way to see what users have permissions on each of the directories in Linux...

Yes, there is a folder called test2 in the current directory. The site is hosted by a third party. How can I tell if the user which the web server runs as is able to write to that directory? How can I find out if the PHP runtime configuration directive safe_mode, is set to "on&quot...

I'm new to PHP and have inherited a site that has a page for file uploading. The site doesn't work. Before jumping in and trying to fix it I thought I'd look at some examples and try to create a simple page first. My example consists of 2 pages (upload.php, upload.html). The code for both is...

onpnt-- I have tried putting in null. I've also tried putting in numbers of existing projects but I get the same error regardless. Turkbear-- Thanks for the recommendation. I'll give it a try. InsaneProgrammer.com

All of the parameters in the procedure are varchar2 (string data types). InsaneProgrammer.com

I am trying to pass 10 parameters to an Oracle procedure and get a recordset returned. The procedure executes correctly in SQL*Plus and when called from an Oracle form. I have searched microsofts knowledge base, oracles metalink, and google extensively and tried numerous ways. The code from...

My WEB-INF/lib directory contains reports_tld.jar. InsaneProgrammer.com

I can't get my Oracle 9i JSP reports to run on Oracle 9iAS. I get the following error: oracle.jsp.parse.JspParseException: Line # 1, Error: java.lang.ClassNotFoundException: oracle.reports.jsp.ReportTagExtraInfo at...

Have you actually used it. I'd like an example if possible. Me error is caused by the ";" in the sql statement. When I take out the semicolon the error changes. It then tells me that me sql statement isn't terminated correctly. It seems like the semicolon isn't getting parsed...

Is it possible to use multiple recordsets with an Oracle Database? If your connecting to SQL Server or mySQL you can do somthing like this: private sub Example Dim sSQL Dim oRS Dim oCON set oCON=server.createobject("ADODB.Connection") oCON.Open ("SOME_CONNECTION_INFO")...