problem of utl file [message #478594] |
Mon, 11 October 2010 03:35  |
narang79
Messages: 137 Registered: June 2010
|
Senior Member |
|
|
sir
following text is used in procedure
but it will create some problem
UTL_FILE.FOPEN('TDS','form26q.txt','w')
how i can check through toad what is the ptroblem
|
|
|
|
|
|
|
|
|
|
|
|
Re: problem of utl file [message #478628 is a reply to message #478625] |
Mon, 11 October 2010 06:05   |
 |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
So, you are connected as ALLENGERSDB. Right? Where did you grant EXECUTE on UTL_FILE to it? Connect as a privileged user, run the following statement and copy/paste the output:select * from all_synonyms where synonym_name = 'UTL_FILE';
[Updated on: Mon, 11 October 2010 06:05] Report message to a moderator
|
|
|
|
|
|
|
|