External procedure

From: AndreaC <Andrea.Cannaos_at_gmail.com>
Date: 26 Oct 2005 02:57:38 -0700
Message-ID: <1130320658.249858.254450_at_o13g2000cwo.googlegroups.com>

Please,
i'm doing some experiments in Microsoft Win2003 environment calling a c function as external procedures.

I've build a sample using Dev-C++ that make a DLL (i don't know c language) named sysDLL.dll
---

DllClass::DllClass(char *cmd)
{
int num;

num = system(cmd);
}
---

I need only to execute some OS command from PL/SQL (rdbms 10.2). I've putted DLL in $ORACLE_HOME\bin.

Then I've created library with this statement : Create Library scott.c_sysdll as
'C:\oracle\product\10.2.0\db_3\bin\sysdll.dll'

and at the end I've created the procedure : create or replace procedure scott.shell(cmd IN varchar2) as language C
library c_SysDll
name "DllClass"
parameters (cmd string);

But when I execute this procedure from sql*plus I've always get :

ORA-06521: PL/SQL: Error mapping function
ORA-06522: Unable to load symbol from DLL
ORA-06512: at "SCOTT.SHELL", line 1
ORA-06512: at line 1

Please help me, thanks ! Received on Wed Oct 26 2005 - 11:57:38 CEST