Re: Help with Trigger PLS-00049

<tjmxyz_at_my-deja.com> schrieb in im Newsbeitrag: 8vldmp$o2b$1_at_nnrp1.deja.com...
> [Trigger Code]
> 11/27 PLS-00049: bad bind variable 'COLORCNT'

Hi Tjmxyz (what a crazy name!),

I think the ":" before "ColorCnt " is too much:

> update styles set moc001=:ColorCnt where mainkey=:new.mainkey;

                                             ^!!!

A variable with a ":" before is a bind variable. That is not the same as an ordinary PL/SQL-variable. In PL/SQL you use variables in SQL-statements just by its name. (If there is a field in one of the tables with the same name as the variable, you have to change the name of the variable or read the ORACLE manuals to find out what has the higher priority: Table fields or variables.)

regards

Holger Kreft

--
Verlion GmbH, Essen
EMail: Holger.Kreft_at_Sutter.de