Hi. We have a couple of bdprocs implemented and they are running fine using kernel build 7.3.0 build 8 and 15. Updating the database to build 21 results in a couple of errors -9991 while executing some of the procedures. The root cause seems to be, that some syntax has changed ?! If I do a "DROP DBPROC X" and try to do a "CREATE DBPROC...." afterwards the system returns error -7056, subquery not allowed.
To summarize: The procedure can be created using build 8 or 51, but cannot be created using build 21. Here is the interesting part of code of the dbproc: /* FETCH OUT ONLY IF WE SHOULD SEE THE ITEM */ INSERT INTO "TEMP"."FS_READ_CURRENTDIR" SELECT "ID", "NAME", "TYPE", "PARAMETER", "TID", "OBJID", "URL1", "URL2", "URL3", "COMMENT", "ORDER" FROM "BLA"."FS_DIRECTORY" WHERE "ID_PARENT" = :ID_FS_DIRECTORY AND "ID" IN ( SELECT "ID_FS_DIRECTORY" FROM "BLA"."FS_ACL"WHERE "ID_ENDUSER" = :ID_ENDUSER AND "PERMISSION" = 1 ); The problem seems to be the subquery inside the "IN" expression. However, any idea how to resolve this issue ? Best Regards, Sascha Appel _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
