reading unix files using PL/SQL [message #1040] |
Sun, 24 March 2002 17:53 |
Sadasivan Anu
Messages: 2 Registered: March 2002
|
Junior Member |
|
|
Hi ,
1. How to send and argument to a procedure .
For examples i count the no of days in a
all_months table using a procudure which will
take the month are argument .
2. Is is possible to read unix file using Procedure
sql if so how ??
|
|
|
Re: reading unix files using PL/SQL [message #1042 is a reply to message #1040] |
Mon, 25 March 2002 00:48 |
Epe
Messages: 99 Registered: March 2002
|
Member |
|
|
Hello,
1. Your procedure should define the incoming arguments
between () after the procedure name. The word IN
defines it as an incoming argument :
"create or replace procedure X(month IN number) is"
You can call the procedure like : X(4), which will
pass the value 4 to the variable "month" in the
procedure.
2. Use the "utl_file" package
Have fun,
Epe
|
|
|