Home » Developer & Programmer » Forms » ORA-06553: PLS-320
ORA-06553: PLS-320 [message #375439] Mon, 23 October 2000 11:55 Go to next message
Messages: 1
Registered: October 2000
Junior Member
I get the following error when I try to set a field in pre-insert. What I am trying to do is when a new record is created, I want a field called ID to be set to the next number in a sequence. However when I try to compile my form I get an error. The line of code is:

select max(id)+1 into :T_PC_COL1.ID from t_pc_col1;

The error I get is:
Error 0 at line 0, column 0
ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-320: the declaration of the type of this expression is incomplete or malformed.

ANy help would be greatly appreciated
Re: ORA-06553: PLS-320 [message #375461 is a reply to message #375439] Fri, 27 October 2000 10:35 Go to previous message
Messages: 8
Registered: October 2000
Junior Member
check data type of colum and item in block. also, if it is not number, check its data, it may be returning chars!
Previous Topic: Query on date in Forms.
Next Topic: Querying on date in Forms
Goto Forum:

Current Time: Sat Mar 02 07:17:29 CST 2024