Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01000: maximum open cursors exceeded
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