View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0001254Database Workbench v5Firebird Modulepublic2015-07-05 14:452015-10-09 12:03
ReporterSascha Assigned ToMartijn Tonies  
PrioritynormalSeverityblockReproducibilityalways
Status closedResolutionfixed 
Product Version5.0.10 
Fixed in Version5.1.6 
Summary0001254: SP syntax validaten error with "in autonomous transaction" statement
DescriptionThis SP is valid and accepted from Firebird but
DW report error "24 END expected but "if" found."

So the StoredProcedure Debugger is not usable !!!
And so on i can not work :-(


SET TERM ^^ ;
CREATE PROCEDURE "DW-Error"
AS
/*
  You can change this template in the template editor:
  File | Preferences | Object Templates

  Procedure:

  Author : ,
  Date : 05.07.2015 14:29:42
  Purpose :
  Params
  ------
  <param> : <purpose>
*/
begin
  if ( 1 = 1) then
  begin
    in autonomous transaction -- Wenn es mit :"Anzahl" ( "AbfrageID" und "I_DokumentID" = 0 aufgerufen wird kann man auch alles expliziet loeschen !!
    do
    
    begin
    end
    
    if ( 1= 1) then
      exit;
  end
  
end ^^
SET TERM ; ^^
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2015-07-05 14:45 Sascha New Issue
2015-07-06 13:51 Martijn Tonies Status new => acknowledged
2015-07-06 13:51 Martijn Tonies Priority immediate => normal
2015-08-31 14:43 Martijn Tonies Assigned To => Martijn Tonies
2015-08-31 14:43 Martijn Tonies Status acknowledged => assigned
2015-09-02 12:46 Martijn Tonies Status assigned => resolved
2015-09-02 12:46 Martijn Tonies Fixed in Version => 5.1.6
2015-09-02 12:46 Martijn Tonies Resolution open => fixed
2015-09-09 11:12 Martijn Tonies Summary SP syntax validaten error => SP syntax validaten error with "in autonomous transaction" statement
2015-10-09 12:03 Martijn Tonies Status resolved => closed