RE: Pro*C and DBMS_PIPE trouble

From: martin_harrison <martin_harrison_at_my-deja.com>
Date: Thu, 11 Jan 2001 15:03:07 GMT
Message-ID: <93khv4$4lc$1@nnrp1.deja.com>

Pat,

Make sure your DBA has granted execute permission on DBMS_PIPE for the desired userid.

Regarding the makefile, copy the demo_proc.mk file to your local directory and add the following line to the end:

PROCFLAGS= sqlcheck=semantics userid=$(USERID)

Then, to compile run the following:

$ make -f makefile build INAME=daemon.pc EXE=daemon OBJS=daemon.o

Load the PLSQL via sqlplus

> start daemon.sql
> show errors;

Then following the execute instructions per oracle: Open two windows, in the first run the daemon (./daemon), in the second start sqlplus and run:

> variable rv number;
> execute :rv := DAEMON.EXECUTE_SYSTEM('ls -la');

Hope that helps.
Martin

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 11 2001 - 09:03:07 CST