Devart Forums

In new versions of ODAC cursor position is restored after refresh. But version 5.55 of ODAC doesn't have such feature.

We cannot reproduce the error. Please specify this situation more detailed. If it is possible send to ODAC support address complete sample that demonstrates the problem and include script to create server objects.

We have fixed this problem. The fix will be included in next build of ODAC.

ODAC doesn't have such feature.

We cannot reproduce the problem. If it is possible send to ODAC support address complete sample that demonstrates the problem and include script to create server objects.

When working with TOraStoredProc you should manually set DataType property to ftXml for XMLTYPE parameters. We have fixed this bug, and the fix will be included in next build of ODAC.

Creating XMLTYPE from LOB with method TOraXML.AllocObject(SvcCtx: pOCISvcCtx; OraLob: TOraLob) does not work on some versions of Oracle client. In that case you can assign value to XMLTYPE parameter using TOraXML.AsString property (if length of the XML text is not more than 4000 characters).

Or you can use temporary CLOB with TOraSQL component. Assign the following text to SQL property:

DECLARE
Result_xml XMLTYPE;
BEGIN
Result_xml := Return_xml(XMLTYPE(:arg));
:Result := Result_xml.GetClobVal;
END;

Set DataType property of parameters ARG and RESULT to ftOraClob. Set ParamType of ARG to ptInput and ParamType of RESULT to ptOutput.

We cannot reproduce the problem. If it is possible send to ODAC support address complete sample that demonstrates the problem and include script to create server objects.

We are working on correcting this error. We will let you know when the bug is fixed.

TOraStoredProc component uses Overload property to create PL/SQL call to stored procedure and to create parameters. But if in your package there is more than one overloaded procedure that can be called with such parameters error will be raised. You should alter your package so that only one overload of procedure RELEASE_PICK_LOT can be called with two parameters of type Float.

We cannot reproduce the error. Please specify versions of Oracle server and client you use and also Delphi version, whether you use Net option to connect to database.
If it is possible send to ODAC support address complete sample that demonstrates the problem and include script to create server objects.