First time i try to reply via e-mail. Let's see how this goes.

On 2018-02-20 01:45:57, 'Jason Wharton' supportlist@... [IBObjects] <ibobjects@yahoogroups.com> wrote:

 

Dany,

 

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?

Jason

---

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Thursday, September 21, 2017 4:07 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] SchemaCahe and Procedure Parameters

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