ORA-1008 with TXMLBroker (doa34d5)

[rodolfo risicato]

Hi to everybody,
I have an Application Server with an OracleDataSet that has 3 variable in the SQL.
When I try to use it from the client, through a TXMLDataBroker, i have an exception: "ORA - 1008 not all variables bound.."
I have fetched all the variables, and I correctly see it in the "Params" property of TXMLDataBroker.
I Have only re-compiled the server.
Where I could have been wrong?
Have I forgotten anything?
Has someone already found this problem?
N.B.
With the version 3.3 all works well.

 

[Marco Kalter]

In version 3.4 the Params from a client application are copied to the Variables of the corresponding TOracleDataSet. This way you can create Params, which will lead to corresponding Variables. In 3.3 this was not the case, so you could have Variables in the TOracleDataSet that did not have matching Params on the client application. If you have only compiled the server, than maybe this can explain the problem.

You can also use the OracleMonitor to find out what SQL is fired, and what the variables are.

------------------
Marco Kalter
Allround Automations

 

[rodolfo risicato]

Hi Marco, thanks for your answer.
I am sorry it a lot, but rereading my message I have realized that I have not been precise in the exposure of the problem.
the exception "ORA-1008 not all variables bound" it's raised at DESIGN-TIME not at RUN-TIME.
At RUN-TIME al work well.
The variable in the object XMLBroker are visible (type ftInput), on the application server, in the event BeforeOpen of the TOracleDataSet I have written the following code:
procedure TADPCHServerDM.OraUtentiBeforeOpen(DataSet: TDataSet);
begin
OracleSession.Connected := True;
end;

do you have some idea?

thanks for your patience, with friendly regards.

Rodolfo Risicato

D5 DOA342.

 

[Marco Kalter]

I know nothing about the TXMLBroker component, but if designtime and runtime behavior are different this usually indicates that you are using events to make things work at runtime. Perhaps an event creates the parameters in the client application?

------------------
Marco Kalter
Allround Automations