How to parse the cursor content.

[Hassan]

Hello all,

I use this code to execute a stored proc..

OraStoredProc.StoredProcName := 'KNGDDW.KNGc_GetList';

OraStoredProc.PrepareSQL; // receive parameters

OraStoredProc.Params[0].ParamType := ptoutput;
OraStoredProc.Params[0].DataType := ftInteger;

OraStoredProc.Params[1].ParamType := ptoutput;
OraStoredProc.Params[1].DataType := ftCursor;

OraStoredProc.Execute;

RsltId := OraStoredProc.Params[0].AsInteger;

now - how do i get and parse the Cursor??

please help ASAP.
thanks alot.

[Paul]

You can use OraStoredProc as TDataSet

Code: Select all

  OraStoredProc.First;
  OraStoredProc.FieldByName(...).AsString...
  OraStoredProc.Next;