hi i am using window xp 2004 and oracle 8i client (in my client machine)
.... i have designed an interface using vfp that connect to oracle 10g
database server in other machine......
now my problem is when i insert some character like Š using designed

I need to run a query, and get a single row for a result. for example,
if the query was:
select site from site_table
and the result would be:

I would like to set a bind variable within a function
I tried the following:
VARIABLE x NUMBER
CREATE OR REPLACE FUNCTION setX

Where would be the best place to get support for Failsafe?
Are there any forums / mailing lists? Is this the right newsgroup to get
answers?
Many Thanks,

Vennela Technologies is a Global Oracle Technologies and Oracle
Applications services Provider with a good customer base in Middle East
and Europe
Vennela started its Training division very recently. We are very happy

I am using JDBC to access Oracle from Java program.  I need to generate a
huge table from reading a another huge input table. Here is the requirement:
1. Read a row from the input table, do calculation, generate a target row.
2. The generated target row may or may not be generated ...

is there an way, to make a difference between the parameter of a
procedure and the column name of a table if the name is equal?
in firebird it is no problem, because in a sql statement I have to use
colon in from of a variable for example:

I have a table with a unique concatenated index on 2 of its NUMBER
datatype columns.  The table only consists of these two columns.
At the moment the table only has 493 rows in it.  Ive heard only to put
indexes on large tables, with more than 1000 rows in it to improve

Hello users. I have a query that I can run and see the result on the grid on
design time, but when i run the program i get the folowing
message:ORA-00979: not a GROUP BY expression. When I run the same query with
out parameters it runs and it was runing well before in Oracle 8 ...

Following is excerpt from the tnsnames.ora file:
SUMSKYDB =
(DESCRIPTION =
 (ADDRESS_LIST =

Hy,
i'm wondering which patch i must apply to my 10g database : 10.1.0.3 or
10.1.0.4 ?
as they publish 10.1.0.3P8, why is there nothing for 10.1.0.4 ?

I have noticed that REDO LOG WRITER is taking very long time. It took
150 ms to write to a datafile.
I have 12 groups with 2 members in each. How do I go about it? What do
I check? Is there a way to see what caused it?

We have 3 databases
A, B and C and the emplyees of our company have accounts in all of
them. We plan to write a front end so that they can manage the passwrds
themselves rather than letting the DBA do that.

We are having a SUN server. In that, we are running 4 different
instances. I need a  startup script to start all the instances.
Regards,
Balu

I can't recall this ever happening before, on a test database (9ir2),
users wanted a fixed point in time to go back to, so I do a clean
shutdown, backup all datafiles (yes, redolog and control files too) to
another drive, restart database, which is not in archivelog mode. About