|Subject||SchemaCahe and Procedure Parameters|
I see many statements like this:
WHERE RDB$PARAMETER_TYPE = ?/* RDB$PARAMETER_TYPE */
AND RDB$PROCEDURE_NAME = ?/* RDB$PROCEDURE_NAME */
ORDER BY RDB$PARAMETER_NUMBER ASC
in my monitoring tables.
I have cleared out the SchemaCache directory and restarted my IBO-based services.
I have (after running a lot of queries) the following files in my SchemaCache direcory:
BlobInfo, CharacterSetInfo, CaracterSetList, ClientSchemaVer, ProcedureNames, TableNames.
The services have most stuff in the DFMs. IB_StoreProc is used but i cannot guarantee that procerures are not called using IB_DSQL or event TIBO-components (have been rooting the out lately).
I usually check newly added components by clicking on the published Params property. Usually i click cancel in the dialog, but sometimes maybe i accidentally hit the OK button. I have many DMs, but the ones i check now have AutoDefineParams = false.
IMHO it is odd that the file ProcedureParams is not created, the record is present in IBO$SCHEMA_VERSION.
More info; IBO 5.9.5 (2667)
Could you please check whats going on?