12-02-04, 19:39 #1Registered User
- Join Date
- Dec 2004
Unanswered: Illegal SPL Routine Entry from dbschema.
i'm on 9.40.fc4, but i know this problem migrated over from 7.31. when i do a dbschema, it dumps out all the schema info until it gets to a specific stored procedure, and this is what it outputs:
-- last part of previuos procedure...
Illegal SPL Routine Entry.
sysprocbody looks fine, and i can dump out the text of the next procedure, but it has this at the beginning, which isn't part of the text that is loaded from our side:
-- All existing object permissions for the object 'getpart'
-- will be automatically restored after this script is executed.
drop procedure getpart;
create procedure getPart( partno int, str varchar(255) )
the comments and the drop aren't part of the code that we load, so where does that come from? and are those the illegal characters that dbschema is complaining about?
i found this as 9.4 dumps the schmea differently than 7.3, dumping the indexes after the tables and sp's. so i have to do a dbschema of the tables, perms, etc... to get the whole db, but i can't dump the sp's. i have to piece it together from dumping out sysprocbody.
12-03-04, 04:23 #2Registered User
- Join Date
- Jun 2004
- Madrid, Spain
It sounds like a deleted-body proecdure or a corruption in sysprocbody.
Can you export the code for each procedure using dbschema -d bbdd -f all, or dbschema -d bbdd -f procedure_name?José Luis Matute.
Regards from Spain.