OraFAQ Forum: Unix » Write to Unix/Linux FIFO

Home » Infrastructure » Unix » Write to Unix/Linux FIFO

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Write to Unix/Linux FIFO [message #49003]

Thu, 06 January 2005 22:49

Fahami
Messages: 22
Registered: December 2004

Junior Member

Hi there,

Is there any way/syntax in Oracle Store Procedure where I can write into Linux/Unix FIFO? I tried to use UTL_FILE utility but cannot. I always get ORA-29283, invalid file operation error.

CREATE OR REPLACE PROCEDURE sp_write_fifo
( iv_path VARCHAR2, iv_file VARCHAR2 )
IS
outf UTL_FILE.FILE_TYPE;
BEGIN
outf := UTL_FILE.FOPEN(UPPER(iv_path), iv_file, 'A');

UTL_FILE.PUT_LINE(outf,'Store Procedure');
UTL_FILE.PUT_LINE(outf,'by Fahami');

UTL_FILE.FCLOSE(outf);
END sp_write_fifo;

I created the path using CREATE DIRECTORY command.

Thanks & Regards

Report message to a moderator

Re: Write to Unix/Linux FIFO [message #49004 is a reply to message #49003]

Thu, 06 January 2005 23:54

Sam
Messages: 255
Registered: April 2000

Senior Member

hi fahami...
first of all where are you executing your procedure from ..... and do you have permissions to the linux machine.... if everything is in place then what type of file operation do you want to execute...

regards ,
sam

Report message to a moderator

Re: Write to Unix/Linux FIFO [message #49005 is a reply to message #49003]

Fri, 07 January 2005 01:46

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Hi,

You can write to a pipe as you would normally write to a plain text file. Here is an example:

Session 1: setup the pipe

$ mknod pipe.txt p
$ cat pipe

Session 2: Write to the pipe

SQL> CREATE OR REPLACE DIRECTORY dir1 AS '/app/oracle';

Directory created.

SQL>
SQL> DECLARE
  2    fileHandler UTL_FILE.FILE_TYPE;
  3  BEGIN
  4    fileHandler := UTL_FILE.FOPEN('DIR1', 'pipe.txt', 'W');
  5    UTL_FILE.PUTF(fileHandler, 'Look ma, I''m writing to a pipe!!!n');
  6    UTL_FILE.FCLOSE(fileHandler);
  7  EXCEPTION
  8    WHEN utl_file.invalid_path THEN
  9       raise_application_error(-20000, 'ERROR: Invalid path for file.');
 10  END;
 11  /

PL/SQL procedure successfully completed.

Best regards.

Frank

Report message to a moderator

Re: Write to Unix/Linux FIFO [message #49013 is a reply to message #49005]

Fri, 07 January 2005 05:38

Thomas G
Messages: 58
Registered: April 2003

Member

Could it propably be that it only works if the other side of the pipe (e.g. the cat) ist already running when you run the procedure ?

Report message to a moderator

Re: Write to Unix/Linux FIFO [message #49015 is a reply to message #49013]

Fri, 07 January 2005 05:47

William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK

Senior Member

It will work but the procedure will hang until something reads off the pipe.

Report message to a moderator

Re: Write to Unix/Linux FIFO [message #49035 is a reply to message #49005]

Sun, 09 January 2005 18:08

Fahami
Messages: 22
Registered: December 2004

Junior Member

Hi,

It can not work! I already did all before. I always got these error when executing the procedure:
BEGIN sp_write_fifo; END;

*
ERROR at line 1:
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 449
ORA-29283: invalid file operation
ORA-06512: at "EMS.SP_WRITE_FIFO", line 5
ORA-06512: at line 1

FYI, the Oracle 9i server is located on the Win 2000 Server. I also have setup a map directory on the Win server to the Linux dir where the FIFO should be write to. The procedure is to be run at the client (the Linux machine).

Thanks & Regards.

Report message to a moderator

Re: Write to Unix/Linux FIFO [message #49036 is a reply to message #49004]

Sun, 09 January 2005 18:10

Fahami
Messages: 22
Registered: December 2004

Junior Member

Hi Sam,

It can not work! I already did all before. I always got these error when executing the procedure:
BEGIN sp_write_fifo; END;

*
ERROR at line 1:
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 449
ORA-29283: invalid file operation
ORA-06512: at "EMS.SP_WRITE_FIFO", line 5
ORA-06512: at line 1

FYI, the Oracle 9i server is located on the Win 2000 Server. I also have setup a map directory on the Win server to the Linux dir where the FIFO should be write to. The procedure is to be run at the client (the Linux machine).

Thanks & Regards.

Report message to a moderator

Re: Write to Unix/Linux FIFO [message #49045 is a reply to message #49036]

Mon, 10 January 2005 14:41

Sunita
Messages: 6
Registered: November 2002

Junior Member

Hi,

Can you change the FOPEN function to the following and give it a try.
outf := UTL_FILE.FOPEN(UPPER(iv_path), iv_file, 'W');

I think that with a 'A' - (stands for append) value for the third parameter, the procedure tries to check for the existence of the file, before appending into the file. If the file does not exist, you can get an error.

Also, when you try to execute the package, you would have to pass parameter values for iv_path and iv_file.
eg.
BEGIN sp_write_fifo('directory_name','file_name') END;

good luck.

Sunita

Report message to a moderator

Re: Write to Unix/Linux FIFO [message #49047 is a reply to message #49003]

Mon, 10 January 2005 18:52

Sam
Messages: 255
Registered: April 2000

Senior Member

alright fahami,
first see whether the linux machine is visible from your windows machine...if yes, then it is shared with windows....then instead of specifying through directory path... first try to read the file by directly assigning the pathname .... if it is working , then your file is not opening under valid permissions.....

Report message to a moderator

Previous Topic:	SQL*Loader errors in the log
Next Topic:	Urgent solution required

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 06:51:13 CDT 2024