TEXT_IO not found...please help.
From: Jim West <Jim_at_jameswest.com>
Date: Thu, 20 Jan 2000 16:51:30 GMT
Message-ID: <3kee8sc14hu9lb4br1uodindn0utjd2ook_at_4ax.com>
Ok...here's the deal. I've discovered that FILE_UTL won't do what I need which is to write a client-side file.
PL/SQL: Item ignored
Date: Thu, 20 Jan 2000 16:51:30 GMT
Message-ID: <3kee8sc14hu9lb4br1uodindn0utjd2ook_at_4ax.com>
Ok...here's the deal. I've discovered that FILE_UTL won't do what I need which is to write a client-side file.
I'm trying to use TEXT_IO in my PL/SQL script and on both my PC and Unix node I receive the following error:
vFileHandle text_io.FILE_TYPE; -- Output file
*
ERROR at line 3:
ORA-06550: line 3, column 15: PLS-00201: identifier 'TEXT_IO.FILE_TYPE' must be declared ORA-06550: line 3, column 15:
PL/SQL: Item ignored
My database runs on a Sun node (Oracle 8.0.4). I have D2K loaded on my PC and am running SQL*Plus 8.0.
I've also tried running this on my Unix node with the same result.
How do I make TEXT_IO "known" ?
Much thanx! Received on Thu Jan 20 2000 - 17:51:30 CET