Search results for query: *

Read the OCI (oracle call interface) developer reference. http://tahiti.oracle.com You will need a free OTN login to access the documentation. . .. Eat, think and be merry . ... ....................... .

What version of the database are you using? Oracle 7/8 has a Context Cartridge Oracle 8i has Intermedia text and 9i has Oracle Text... If you are using 9i you have a couple options. There are three main index types. Context, ctxcat and ctxrule. Context indexes are the most flexible, but...

What are you trying to use the ALTER command to do? Convert LONG columns to CLOB? . .. Eat, think and be merry . ... ....................... .

Please also note that "like '%CONST'" will not use any index on the column. Assuming the date column is a DATE datatype, then you might want to do: [code] SELECT to_char(DATE, 'MON-YY') FROM X WHERE DATE between '01-JAN-2003' and '31-JAN-2003' GROUP BY to_char(DATE, 'MON-YY')...

You probably need to modify your include and library paths to include the current directory. Your library path probably needs to include $ORACLE_HOME/lib . .. Eat, think and be merry . ... ....................... .

Modify the location of the oracle home in /var/opt/oratab I assume you are using /usr/local/bin/oraenv to set up the environment for users of the database, including your oracle user. If you aren't using oraenv, then you will need to modify the login scripts and change the $ORACLE_HOME...

Please note I replied to your other thread as well.. The oracle box could just send a mail to the mail server every x minutes to a "watchdog" account. Have cron check the mtime on the watchdog mailbox and if it isn't modified every x+1 minutes then page. That makes sure sendmail is...

The easiest wasy would be to ssh or rsh to execute the TNSping on a remote machine that has the client and return the result. Another way would be to set up a web server that has the libraries and can contact oracle (the Apache that comes with oracle comes to mind) and use it to test the...

Also verify that the memory parameters in /etc/system haven't been changed. The memory parameters might be somewhere else depending on what OS you are running. . .. Eat, think and be merry . ... ....................... .

is your database listed in /var/opt/oracle/oratab ? . .. Eat, think and be merry . ... ....................... .

SQL*Plus doesn't display the DOS box, only SQL Worksheet. I never use SQL worksheet personally. I just stick to either sqlplus (dos version) or sqlplusw (windows version) of regular SQL*Plus I rarely use SQL*Plus for anything but reporting, or when sitting on a unix shell. For regular SQL...

Do you have a DBA that is killing off long running (apparently) idle sessions? . .. Eat, think and be merry . ... ....................... .

Did you change your init.ora? That will happen if you set LOCK_SGA but your system isn't set up to support it. You can only lock shared memory areas as root, so oracle has to run as the root user, which is a bad thing. . .. Eat, think and be merry . ...

SQL*Plus worksheet works by "hooking" to the SQL*plus dos executable to perform its work. As far as I know, there isn't any way to avoid that, so you are pretty much stuck with the dos box. If it really annoys you, you can get a program from somewhere like Download.com to hide...

Why not just connect to the oracle database from the web server using ADODB (I assume you are using IIS and ASP) and run queries against it? You will need to install the oracle client on the web server and set up your tnsnames file, then you should be able to use ASP to connect to your oracle...

I think it may be used by the database when you are doing OS level authentication. I think a user can have an oracle username that is different from their OS username. When you use OS authentication, I believe the OS username is in the external_name field. I think it is also used when...

Context => CTXSYS Enterprise Man => DBSNMP JAVA => ORDSYS, ORDPLUGINS Spatial => MDSYS UltraSearch => WKSYS Stored Outlines => OUTLN StatsPack => PERFSTAT You may have the following users associated with web services AURORA$JIS$UTILITY$...

are you sure there isn't a RAISE_APPLICATION_ERROR somewhere in the code that is raising that exception? Perhaps you might do a search in dba_source and see if the error is raised somewhere. If it is data dependent then it may be that a programmer put in an exception for invalid combinations...

just out of curiousity is SQLJ supported on all those platforms? If you can write a stored SQLJ procedure to do it that would be your best bet, since it will work on all three databases (assuming it is supported in all three) alternatively: In oracle to use a single SQL query you could...

That would work, assuming that you have not written any data to the web browser, or that you have buffering enabled. That said, however, what you are coding could result in a serious security hole and will result in some pretty unmanagable code. a) Think about what will happen when you have...