| Subject | SchemaCahe and Procedure Parameters |
|---|---|
| Author | |
| Post date | 2017-09-21T10:07:15Z |
Jason,
I see many statements like this:
SELECT RDB$PARAMETER_NAME
FROM RDB$PROCEDURE_PARAMETERS
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?
TIA,
/Dany