Triggers [message #21512] |
Thu, 08 August 2002 13:57 |
Riya
Messages: 7 Registered: March 2001
|
Junior Member |
|
|
When creating a trigger for my table I get an compilation error because I have a column named NUMBER. It would be a problem to rename this column so is there anyway around it?
ERROR:
ORA-06553: PLS-488: invalid variable declaration: object 'NUMBER' must be a
type or subtype
|
|
|
Re: Triggers [message #21513 is a reply to message #21512] |
Thu, 08 August 2002 15:01 |
ram kumar
Messages: 113 Registered: August 2002
|
Senior Member |
|
|
hi riya
as number is a reserved word you need to rename a column.
one more oprtion depends on code
can you tell me how you are refering number column in that code..i might help you
regards
ram
|
|
|
Re: Triggers [message #21536 is a reply to message #21512] |
Sat, 10 August 2002 06:27 |
Sheshadri
Messages: 12 Registered: June 2002
|
Junior Member |
|
|
Hi,
I do not know whether you can rename a column or not?
If You know you can help me.
I think if you refer the column within double quotes the problem might be solved.Yet don't know, you can try it.
|
|
|