Re: ORA-01000: maximum open cursors exceeded

From: ianal Vista <ianal_vista_at_hotmail.com>
Date: Sat, 17 Jun 2006 14:43:19 GMT
Message-ID: <Xns97E54EB533B10ianalvistahotmailcom@70.169.32.36>

"Oliver Neumann" <no_at_no.com> wrote in news:e713v6$1up$03$1_at_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.
>
>

Only if/when the RETURNING clause is used. Received on Sat Jun 17 2006 - 09:43:19 CDT