How to drop a system event trigger - endless loop?

2001-06-05 Thread Andor, Gyula
-- Author: Andor, Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send

RE: How to pass the connect clause to connect as a database user

2001-05-29 Thread Andor, Gyula
://www.orafaq.com -- Author: Andor, Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

Function based index - insufficient priveleges

2001-05-28 Thread Andor, Gyula
func_idx_lang_name on lang (upper(lang_name)); I have "create any index privilege" Enviroment: Oracle 8.1.6 on WinNT Thanks in advance. Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor, Gyula INET: [EMAIL PROTECTED] Fat City Network Services--

RE: Function based index - insufficient priveleges

2001-05-28 Thread Andor, Gyula
Thank you ! This solved the problem. Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor, Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Decode in PL/Sql

2001-05-17 Thread Andor, Gyula
Hi Gurus ! Is there any function that can be used in PL/SQL and just works the way as DECODE does in Sql? Thanks in Advance Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor, Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Designer 6i Question - Database Desig Transformer - Unique Key Mi

2001-05-09 Thread Andor, Gyula
. Any Idea? Thanks in advance. Gyula We use Designer 6ir2. Does anyone have a list of fixed bugs in 6i r3? I wolud like to know if it's worth downloading and upgrading. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor, Gyula INET: [EMAIL PROTECTED] Fat City

data encryption

2001-05-03 Thread Andor, Gyula
encryption. What do you suggest? Thanks in advance Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor, Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: data encryption

2001-05-03 Thread Andor, Gyula
you can always go with the UNIX crypt() function. That works pretty well ;). And what colud we use on WinNT? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor, Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

RE: Selecting into Var with no recs returned

2001-04-27 Thread Andor, Gyula
THEN p_error_code := 100; RETURN; END IF; TIA, Woody -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor, Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

Overlapping date intervals?

2001-04-18 Thread Andor Gyula
FAQ: http://www.orafaq.com -- Author: Andor Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from th

RE: Problem with DBMS_SQL

2001-04-18 Thread Andor Gyula
(sqlerrm,1,100); INSERT INTO errors VALUES (sysdate, 'A:CT', a, b); END create_table_mbn015; / -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Oracle License Question

2001-04-09 Thread Andor Gyula
Hi Gurus ! Do I need another license if I want to set up a new instance? I mean leaglly.. :) Thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

AUTHID CURRENT_USER across DATABASE LINK

2001-04-02 Thread Andor Gyula
see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: If-statement

2001-03-20 Thread Andor Gyula
lace where it is a ?. If it is not a ? then it will be the no change in that place. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

Designer repository question.

2001-02-22 Thread Andor Gyula
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Designer Error Message - What's wrong?

2001-02-21 Thread Andor Gyula
no entity called MASTER in the dump file to export. Thanks in advance. Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Which is faster?

2001-02-20 Thread Andor Gyula
://www.orafaq.com -- Author: Andor Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing

Re: OFFTOPIC: PL/pgSql Documentation

2001-02-02 Thread Andor Gyula
Thank You ! "Weaver, Walt" wrote: Try http://www.se.postgresql.org/docs/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

OFFTOPIC: PL/pgSql Documentation

2001-02-01 Thread Andor Gyula
Hi Gurus ! Sorry for OFFTOPIC but I need a reference about PostgreSql's PL/pgSql. Can anyone help me? Is't dowanloadable? THanks in advance Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor Gyula INET: [EMAIL PROTECTED] Fat City Network Services