Is Help did'nt update? How to send current record as cursor to Oracle procedure?

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
herbert
Posts: 17
Joined: Sun 08 Oct 2006 19:36
Location: Taipei,Taiwan

Is Help did'nt update? How to send current record as cursor to Oracle procedure?

Post by herbert » Sat 14 Oct 2006 22:29

Hello!
I have set up ODAC 5.8 trial version for BCB5, and start to learn it. There has some question:
(1) In Hierarchy chart, TOraObject is inherit from TDBObject, but in TOraObject help description, Hierarchy did'nt show TDBObject, what's wrong?
(2) In Help, TOraQuery->Options has 8 members, but in Object Inspector show 20 members. Is help didn't update?
(3) Are TOraScript and TDAScript designed for same purpose?
(4) How can I send current record as a cursor to Oracle Procedure?
ex: PROCEDURE EmpPostRec (vOldKey IN VARCHAR2, cCursor IN OUT CURSORTYPE, nCanDo OUT NUMBER, vPlsMsg OUT VARCHAR2)
While post insert record, vOldKey is null; post update record, vOldKey is Key columns value String separated by CHR(1).
I hope do hole transaction by Oracle procedure rather then by TOraScript or TDAScript or TOraQuery->SQLInsert/SQLUpdate.

Thank's!

herbert
Posts: 17
Joined: Sun 08 Oct 2006 19:36
Location: Taipei,Taiwan

About Cursor

Post by herbert » Mon 16 Oct 2006 05:01

After search forums, I know CorLab ODAC does not support input REF CURSOR parameters!
So, forget my question (4).
Thanks!

Challenger
Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Mon 16 Oct 2006 12:43

Thank you for assistance. We'll correct these flaws in our help in the next version.

Post Reply