cagatay ozpolat
Member
Hello;
I'm working with dbms_debug package and I'm using TOraclePackage.
I've two question about usage of TOraclePackage.
1)
By using TOraclePackage, how can I call and read the following Oracle Object.
TYPE xxxx IS TABLE OF VARCHAR2(64);
2)
on dbms_debug package there exist
FUNCTION CONTINUE
( run_info IN OUT runtime_info,
break flags IN BINARY_INTEGER,
info_requested IN BINARY_INTEGER :=NULL
) RETURN BINARY_INTEGER;
Using PL/SQL I could call this function as the following
dbms_debug.continue(
xxxx,
yyyy,
0 +
dbms_debug.info_getlineinfo +
dbms_debug.info_getbreakpoint +
dbms_debug.info_getstackdepth +
dbms_debug.info_getoerinfo +
0);
Above PL/SQL calling style, because info_getlineinfo,dbms_debug.info_getbreakpoint,dbms_debug.
info_getstackdepth and dbms_debug.info_getoerinfo are PLS_INTEGER datatypes. I read that
"PLS_INTEGER datatypes have the same range as the BINARY_INTEGER datatype, but use machine arithmetic
instead of library arithmetic, so are slightly faster for computation-heavy processing.".
In this case how can enter the following value
"
0 +
dbms_debug.info_getlineinfo +
dbms_debug.info_getbreakpoint +
dbms_debug.info_getstackdepth +
dbms_debug.info_getoerinfo +
0
"
of parameter info_requested using TOraclePackage.
Is the following approach is true. On Delphi,the following summation produce correct result as PL/SQL function call mechanism?
"
0+
OraclePackage1.getParameter(info_getlineinfo)+
OraclePackage1.getParameter(info_getbreakpoint)+
OraclePackage1.getParameter(info_getstackdepth)+
OraclePackage1.getParameter(info_getoerinfo)+
0
"
If not how can I do this? Or is there any way for OraclePackage1.CallIntegerFunction to pass this summation using following
"
0 +
dbms_debug.info_getlineinfo +
dbms_debug.info_getbreakpoint +
dbms_debug.info_getstackdepth +
dbms_debug.info_getoerinfo +
0
"
without any change?
Sincerely
Cagatay Ozpolat
I'm working with dbms_debug package and I'm using TOraclePackage.
I've two question about usage of TOraclePackage.
1)
By using TOraclePackage, how can I call and read the following Oracle Object.
TYPE xxxx IS TABLE OF VARCHAR2(64);
2)
on dbms_debug package there exist
FUNCTION CONTINUE
( run_info IN OUT runtime_info,
break flags IN BINARY_INTEGER,
info_requested IN BINARY_INTEGER :=NULL
) RETURN BINARY_INTEGER;
Using PL/SQL I could call this function as the following
dbms_debug.continue(
xxxx,
yyyy,
0 +
dbms_debug.info_getlineinfo +
dbms_debug.info_getbreakpoint +
dbms_debug.info_getstackdepth +
dbms_debug.info_getoerinfo +
0);
Above PL/SQL calling style, because info_getlineinfo,dbms_debug.info_getbreakpoint,dbms_debug.
info_getstackdepth and dbms_debug.info_getoerinfo are PLS_INTEGER datatypes. I read that
"PLS_INTEGER datatypes have the same range as the BINARY_INTEGER datatype, but use machine arithmetic
instead of library arithmetic, so are slightly faster for computation-heavy processing.".
In this case how can enter the following value
"
0 +
dbms_debug.info_getlineinfo +
dbms_debug.info_getbreakpoint +
dbms_debug.info_getstackdepth +
dbms_debug.info_getoerinfo +
0
"
of parameter info_requested using TOraclePackage.
Is the following approach is true. On Delphi,the following summation produce correct result as PL/SQL function call mechanism?
"
0+
OraclePackage1.getParameter(info_getlineinfo)+
OraclePackage1.getParameter(info_getbreakpoint)+
OraclePackage1.getParameter(info_getstackdepth)+
OraclePackage1.getParameter(info_getoerinfo)+
0
"
If not how can I do this? Or is there any way for OraclePackage1.CallIntegerFunction to pass this summation using following
"
0 +
dbms_debug.info_getlineinfo +
dbms_debug.info_getbreakpoint +
dbms_debug.info_getstackdepth +
dbms_debug.info_getoerinfo +
0
"
without any change?
Sincerely
Cagatay Ozpolat
