da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: uses DBM_DEBUG

Forum List » NCOCI8 » General English

philippe
User

Junior Boarder

Posts: 13

Karma: 0

uses DBM_DEBUG

Posted: 2003/05/17 22:50

I want use DBMS_DEBUG package.
Some procedures or functions use parameters with non standard datatype and generate errors ora or oci. How is it possible to use it?

Diman

Admin

Posts: 1495

Karma: 19

RE: uses DBM_DEBUG

Posted: 2003/05/28 14:00

Which one ?
Also if it is not possible directly to use some procedure create a PL/SQL wrapping procedure with supported parameters.

Regards,
Dmitry

philippe
User

Junior Boarder

Posts: 13

Karma: 0

RE: uses DBM_DEBUG

Posted: 2003/05/28 15:18

just an example, the execution of prepare on dbms_debug.continue gives this error
ORA-01036 illegal variable name/number.

I Think that the reason is the use of type defined in Oracle Type

Diman

Admin

Posts: 1495

Karma: 19

RE: uses DBM_DEBUG

Posted: 2003/05/28 18:30

Nested PL/SQL tables are not supported by TOCIStoredProc. You should use wrapping stored proc. For example:

FUNCTION Mycontinue(run_info IN OUT Myruntime_infoWithoutProgramInfo, prog_info IN OUT program_info, breakflags IN BINARY_INTEGER, info_requested IN BINARY_INTEGER := null);

Regards,
Dmitry

Diman

Admin

Posts: 1495

Karma: 19

RE: uses DBM_DEBUG

Posted: 2003/05/28 18:31

Oops, sorry. I mean not "nested PL/SQL tables", but "nested PL/SQL records".

philippe
User

Junior Boarder

Posts: 13

Karma: 0

RE: uses DBM_DEBUG

Posted: 2003/05/29 14:13

If I unerstand, I must create a PLSQL function without record which calls the Oracle's procedures?

I will try, thanks
Philippe

Forum List » NCOCI8 » General English