Sascha Appel wrote : >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. I suppose you mean error -9111. This problem has already been reported and we have found the reason in the meantime. The reason is an uninitialized byte in the procedures byte code, which became obvious with build 21. >The root cause seems to be, that some syntax has changed ?! No, no syntax changes have been made. >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 ? I tried to reproduce the problem with a procedure similar to your code part, but unfortunately without success. Maybe you can send me the complete procedure definition and some information about your environment ? Thomas --- Thomas Anhaus SAPDB, SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
