|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: how i display a sysdate and user on the display item form (merged) [message #470059 is a reply to message #470055] |
Sat, 07 August 2010 14:57  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
What happens if you don't SELECT at all, but - instead - do this:
:block3.display_item7 := sysdate;
What is your operating system? Which Forms version do you use? Is this combination certified? Because, ORA-00600 is a nasty one and usually means that you should contact Oracle Support and report the error as a bug. However, depending on information you didn't share, perhaps that can be avoided. So?
[EDIT] Forgot to mention: I don't have Forms installation here, but Cookiemonster said that you selected SYSDATE from "emp" table. If it contains more than a single record (and it most probably does), and knowing that in PL/SQL you have to SELECT INTO, you'll get TOO-MANY-ROWS. So, if you insist on select statement, use "dual", not "emp".
SQL> declare
2 l_now date;
3 begin
4 select sysdate into l_now from dual;
5 end;
6 /
PL/SQL procedure successfully completed.
SQL> l4
4* select sysdate into l_now from dual;
SQL> c/dual/emp
4* select sysdate into l_now from emp;
SQL> l
1 declare
2 l_now date;
3 begin
4 select sysdate into l_now from emp;
5* end;
SQL> /
declare
*
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 4
SQL> [Updated on: Sat, 07 August 2010 15:02] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
