| CURRENT RECORD [message #339958] |
Sun, 10 August 2008 06:25  |
sajidrazmi
Messages: 47
Registered: August 2008
Location: oman
|
Member |
|
|
HI EVERYBODY
I HAVE WRITTEN THIS CODE IN POST-SELECT BUT IT IS GIVING ERROR
DECLARE
CUR_ITEM VARCHAR2(80);
CUR_BLOCK VARCHAR2(80):= :System.Cursor_Block;
BEGIN
CUR_ITEM := GET_BLOCK_PROPERTY(CUR_BLOCK,FIRST_ITEM );
WHILE (CUR_ITEM IS NOT NULL )
LOOP
CUR_ITEM := CUR_BLOCK ||'.'||CUR_ITEM;
SET_ITEM_INSTANCE_PROPERTY (CUR_ITEM,CURRENT_RECORD,VISUAL_ATTRIBUTE,'DISP_ONLY_LOOK');
CUR_ITEM := GET_ITEM_PROPERTY( CUR_ITEM, NEXTITEM );
END LOOP;
END;
I AM NOT COMPILING IT IT GIVES ME ERROR
PLEASE HELP ME.
|
|
|
|
|
|
| Re: CURRENT RECORD [message #340008 is a reply to message #339985] |
Mon, 11 August 2008 00:13  |
sajidrazmi
Messages: 47
Registered: August 2008
Location: oman
|
Member |
|
|
hi dear
when i am going to compile it gives that error
begin declare exit for goto if loop mod null pragma raise return select update while an<identifier> <a double quoted delimited identifier> a bind variable <<close curent delete fetch lock insert open rolback
save point set sql commit <a single-quoted sql sting>
the symbol ''''was ignored
i have written this code post-select trigger
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
