DevOps, CI/CD and Automation

Hi,

Can any one let me know how I can install and use this debug_extproc package. I have installed oracle XE server on Linux machine(32-bit).

When I use : DEBUG_EXTPROC.STARTUP_EXTPROC_AGENT' ... i get an error saying that : it is not declared.

I tried looking in all the directories but did not find the dbgextp.sql(which is required in order to install that package).And tried searching on google but could not get any relevant information.

Also I am newbie to OCI call interface and also to C programming too: I have coded a external procedure or custom user aggregate in C. But since I was using C++ : 'set' STL. I have compiled my program using g++ instead of gcc and I have correspondingly modified the make file in public/demo directory.

So, is it fine to do it that way: using OCI (instead of OCCI(C++)) but again compiling the pgm as a regular C++ using g++ instead of gcc.(But rest of the pgm including printf statements : everything is in C).

Also I have created the library from my : custagg.so library:

SQL> create or replace library custagg is '$ORACLE_HOME/lib/custagg.so'

But my aggregate function implemented as external C function using OCI is either not recognised or else : if recognized then there is some error because of which i am getting the following errors : ORA-06522

SQL> select MinDistance(TT) from egg1;
select MinDistance(TT) from egg1
*
ERROR at line 1:
ORA-06520: PL/SQL: Error loading external library
ORA-06522: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/custagg.so:
cannot dynamically load executable


Please kindly answers my queries and trying to resolve this for almost 4 days now and could not find any clue on how to get this done.

Thanks,
-NN