QualityCentral

Public Report

Report From: InterBase [ Add a report in this area ]

Report #: 62364

Status: Resolved

bug when modify a trigger that execute a proc after changin that proc arguments

Project: InterBase

Build #: 8

Version: 8.0

Submitted By: isaac sam

Report Type: Basic functionality failure

Date Reported: 5/20/2008 7:27:37 AM

Severity: Serious / Highly visible problem

Last Updated: 6/27/2008 5:19:15 PM

Platform: All platforms

Internal Tracking #:

Resolution: Need More Info (Resolution Comments)

Resolved in Build: : None

Duplicate of: None

Voting and Rating

Overall Rating: No Ratings Yet

0.00 out of 5

Total Votes: 2

Description

This error appear when I try to modify a trigger that call a stored procedure.

Error:

Invalid token.
invalid request BLR at offset 26.
parameter mismatch for procedure
<procedure name>.

Steps to Reproduce:

After I modified a stored procedure parameters I go to every trigger that call this procedure to modify the passing parameters

Workarounds

Thanks to Craig Stuntz [TeamB] he described this bug more and said a workaround for it, That I have to comment the execute line compile then uncomment , modify the parameters then compile again.

Due to the fact that in some cases, it seems to
validate the arguments to a procedure when you change a trigger which
calls it. But, when you change the procedure itself, it doesn't always
seem to find triggers which called the procedure .

Many thanks
Isaac

Attachment

None

Comments

None

Developer Tools

Database Tools