Re: altering table and column comments from PL/SQL

Nothing really to help your problem but you appear to use Hungarian naming convetions. If that's so, then you should note that VARCHAR is not a zero terminated string (as implied by your variable name szSQL). VARCHAR type is a counted string.

 Sorry to dump on you, but having done a lot of maintenance on ProC code where the programmer didn't understand the difference, it's become a pet peeve of mine. (and I'm obviously no fan of Hungarian notation either).

Adam Rothberg wrote:
>
> Good point! Sorry:
>
> It's a trigger on a table I'm using to store comments for reporting.
> When this table is updated, i want the comments on the
> table/view/column to be updated...
>
> TRIGGER DOCS_COMMENTS
> AFTER INSERT OR UPDATE ON ELLIPSIS_DOCS
> FOR EACH ROW
> DECLARE
> szSQL VARCHAR2(1000);
> BEGIN

-- 
Edward J. Prochak   --- Magic Interface, Ltd.
Ofc: 440-498-3700
on the web at       --- http://www.magicinterface.com
email: ed.prochak_at_magicinterface.com