Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Extproc on NT
The other thing which you should be aware of is that oracle does not have
end of string marker '\0'.
tom
John Chiu <johnymc_at_netscape.net> wrote in message
news:WN1a4.868$kB3.2103773247_at_news1.tor.primus.ca...
> have you defined the external procedure in tnsname.ora
>
> John Chiu
>
> <sergeysergeyev_at_my-deja.com> wrote in message
> news:84a75e$ovb$1_at_nnrp1.deja.com...
> > Did anybody try to execute NT command line from PL/SQL via External
> > Procedure call?
> > I try to do following:
> > C module:
> > #include <windows.h>
> >
> > #define NullValue -1
> >
> > long __declspec(dllexport) exec(char *cmd)
> > {
> > if (_execlp (cmd, cmd, NULL) == -1) return -1;
> > return 1;
> > }
> >
> > PL/SQL module:
> > CREATE OR REPLACE LIBRARY OraDos IS 'D:\1\OD\od.dll'
> > /
> >
> > CREATE OR REPLACE FUNCTION F_OSRUN (cmdin IN VARCHAR2) RETURN
> > BINARY_INTEGER IS
> > EXTERNAL
> > NAME "exec"
> > LANGUAGE C
> > LIBRARY OraDos
> > PARAMETERS (cmdin STRING);
> > /
> >
> > When I call this function, I recieve error message:
> > ORA-28576: lost RPC connection to external procedure agent
> > and function executes command line, or function does nothing and I
> > recieve no message.
> > What's wrong?
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Wed Dec 29 1999 - 00:33:22 CST