Re: ORA-01000: maximum open cursors exceeded

From: Oliver Neumann <no_at_no.com>
Date: Sat, 17 Jun 2006 16:36:07 +0200
Message-ID: <e713v6$1up$03$1@news.t-online.com>

Hey Ed,

> Looks like you've solved the root problem, but just as a pointer on
> your code.. you don't need a separate statement to get the next seq.
> num. Just include it in your INSERT statement:
>
> INSERT INTO employees
> VALUES (employees_seq.nextval,
> 'John',
> 'Doe',
> 'jdoe',
> '555-1212', TO_DATE(SYSDATE)
> );

Yeah i know. But i need to get the Primary Key as im holding virtual rows which needs the PKey-values and an insert-statement dont give me back the pkey as far as i know.

But thanks anyway...
oliver Received on Sat Jun 17 2006 - 09:36:07 CDT