|Subject||RE: [IBO] SchemaCahe and Procedure Parameters|
I don't cache the procedure params info in a static file like I do other schema cache information. I use a live query to grab that info from the server on an as-needed basis.
I don't exactly remember why I went with that as a design-decision, but that's what is going on right now.
Is this causing you some trouble somehow?
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Thursday, September 21, 2017 4:07 AM
Subject: [IBO] 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?