Re: open cursors problem

has a cap of 750 open cursors after which the db will crash. > > Since > > this is the first time I have faced this problem I would be grateful > > if > > anyone could point out what could be the possible areas that could > > cause > > this problem ( other th

open cursors problem

://www.orafaq.com -- Author: Gavin D'Mello 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

Re: Oracle Performance Tuning steps

Hi,         I'm working on a pidley sized db ( about 100mb) but sometimes when I try compiling a decent sized package i get a time out error saying the object is locked, while at other times the package compiles on the fly.         I'm trying to figure out why i get this error randomly. Som

Basic Database Question

Title: Strange problem with charactersets Hi I'm just about to ask a really trivial question which has never struck me before.   If i write a simple select like   select c.contentid from content c,persusercontentassoc p,teachercontentassoc twheret.contentid = c.contentid ORp.contentid = c.co

Re: Get the Latest Date

s in the table, I was trying to > find a way to get me just one row per user which returns the latest date, > rather than checking for the latest date in the client logic. > Is there any function in Oracle which would return the latest date ? > > Thank You, > > Gavin >

Get the Latest Date

latest date ? Thank You, Gavin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gavin D'Mello INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Insert is very slow

Title: Message I'm trying to do a bulk insert using DBI and Oracle for about 248 rows,this is proving to be pretty slow and expensive. Is there anyway where I cando a bulk insert ? I am using prepare_cached and execute with parameters.Thanks so much,Gavin - Original Message -

Re: IMPORTING a dump from a different system

the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gavin D'mello IN

IMPORTING a dump from a different system

rafaq.com -- Author: Gavin D'mello 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 thi

Re: Binary Search in Oracle

> ascending or descending given a particular id. This is performed a s a > binary tree search > > anyone remembers the syntax ? > > Thank you > > Gavin > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Gavin D'mel

Binary Search in Oracle

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gavin D'mello INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Re: Return VArray to Java through JDBC?

--- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the n

Re: Return VArray to Java through JDBC?

--- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the nam

Oracle 8.1.7 on Suse 7.2

tuff. > > See metalink for details. > > Jared > > On Saturday 15 December 2001 06:25, Gavin D'mello wrote: > > Hi I am facing a problem on Suse 7.2 and would be grateful if anyone could > > help me out > > > > I am installing Oracle 8.1.7 on Suse Linux

Create a database without using DbAssist

(like subscribing). > > > > > __ > Do You Yahoo!? > Check out Yahoo! Shopping and Yahoo! Auctions for all of > your unique holiday gifts! Buy at http://shopping.yahoo.com > or bid at http://auctions.yahoo.com > --

Oracle 8.1.7 on Suse 7.2

ng). > > > > > __ > Do You Yahoo!? > Check out Yahoo! Shopping and Yahoo! Auctions for all of > your unique holiday gifts! Buy at http://shopping.yahoo.com > or bid at http://auctions.yahoo.com > -- > Please see th

Re: List users planning to meet during Open world

Hi, is there a way to get the size in MB of a particular table in my database ? Thank You, Gavin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gavin D'mello INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-505

Re: Initialize Varrays

as gtcount is valid. -Original Message-From: Gavin D'mello [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 18, 2001 7:00 AMTo: Multiple recipients of list ORACLE-LSubject: Initialize Varrays Hi,         I am working on Varrays in PL/SQL an

Initialize Varrays

Hi,         I am working on Varrays in PL/SQL and till date the documentation provides a detailed description on how to create and initialize Varrays. However, it does not state the fact that when the Varray is extended, the new element is null and so any attempt to insert values into it, re