Is Help did'nt update? How to send current record as cursor to Oracle procedure?
Posted: 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!
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!