Forms Builder PL/SQL [message #355457] |
Fri, 24 October 2008 03:10 |
Alcatros
Messages: 2 Registered: October 2008 Location: Australia
|
Junior Member |
|
|
Hi guys,
I'am having a problem.
I got a Layout and i have a button which is supposed to create a "fresh page" where i can insert new values
Select cust_seq.nextval from dual;
It says after it needs a into statement... so i thought yea that makes sense ...
Select cust_seq.nextval into customer_form_field from dual;
My layout has 4 Fields where i can input data, 2 buttons one is supposed to create a new entry and the other should save the inputted data.
after that it doesn't work either.. and i have no idea why?
Can somebody give me some help?
Thanks very much!
Oliver
[Updated on: Fri, 24 October 2008 03:12] Report message to a moderator
|
|
|
Re: Forms Builder PL/SQL [message #355460 is a reply to message #355457] |
Fri, 24 October 2008 03:24 |
Alcatros
Messages: 2 Registered: October 2008 Location: Australia
|
Junior Member |
|
|
Ok sorry for the stupid question, found out after posting and 4 hours of searching does it is
answer:
SELECT sequence.NEXTVAL
Into :dbtable.row_val
FROM dual;
|
|
|