Forms :: How To Get File Directory Path Dynamically In The Report
Sep 6, 2013
I want to get file directory path dynamically with out using directory in database or not hard code like below
the purpose is i need to check image in the path directory if not found i unable to generate report, is there any possible to get dynamically
function CF_URLFormula return Char is
v_handle utl_file.file_type;
v_file_dir VARCHAR2(60) := '/u002/app/applmgr/temp/';
begin
v_handle := utl_file.fopen(v_file_dir, :photo_name, 'R');
utl_file.fclose(v_handle);
RETURN v_file_dir||:photo_name;
exception
when others then
srw.message(100,SQLERRM);
return null;
end;
View 1 Replies
ADVERTISEMENT
May 10, 2011
how we can find file path dynamically. In paramenter we can give only destination file name like EXCEL.EXE. and its give me full path of EXCEL.EXE file.
View 1 Replies
View Related
Aug 1, 2013
I am doing steps to run report in Forms....
when I running command rwserver server=reportserver10g in command prompt I am getting orapls10.dll file not dynamically attached error...
Forms and Reports and Database in my system only(practice purpose).
View 1 Replies
View Related
Oct 27, 2011
I create a directory using this:
CREATE DIRECTORY xml_data AS 'c:\mytest';
How can I retrieve the 'C:mytest' in a select statement?
View 5 Replies
View Related
May 13, 2012
I started working on utl_files. When i Am working on this topic I struck with an error: Quote:ORA-29280: invalid directory path. Below are the steps I followed to work on utl_files,
STEP1: connect sys as sysdba
STEP2: @$ORACLE_HOME/rdbms/admin/utlfile.sql
STEP3: create or replace directory utl_data_files as '/home/oracle/siva/data/'; --(the directory path is already exists in the OS)
STEP4: below is the code
DECLARE
out_file UTL_FILE.file_type;
linebuf varchar2(1999);
directory_name varchar2(100):='utl_data_files';
BEGIN
out_file:=UTL_FILE.fopen(directory_name,'emp.dat','W');
for emp_cur in (SELECT * FROM scott.EMP)
[code].....
STEP5: then it's giving the below result/error info
Quote:
SQL ERRORCODE IS:-29280
SQL ERROR MSG IS:ORA-29280: invalid directory path
PL/SQL procedure successfully completed.
View 2 Replies
View Related
Sep 9, 2013
When i am running the below script i am getting error like Invalid directory path. how to check the path by using dbms_ouput.
error : ORA-29280: invalid directory path
ORA-06512: at line 34
DECLARE
l_out_file UTL_FILE.file_type;
g_convert_crlf BOOLEAN := TRUE;
P_DATA VARCHAR2(32767);
l_buffer VARCHAR2(32767);
l_amount BINARY_INTEGER := 32767;
l_pos INTEGER := 1;
[code].....
View 1 Replies
View Related
Apr 9, 2013
When i am running the below script i am getting error like Invalid directory path. how to check the path by using dbms_ouput.
error : ORA-29280: invalid directory path
ORA-06512: at line 34
DECLARE
l_out_file UTL_FILE.file_type;
g_convert_crlf BOOLEAN := TRUE;
P_DATA VARCHAR2(32767);
l_buffer VARCHAR2(32767);
l_amount BINARY_INTEGER := 32767;
[code]....
View 11 Replies
View Related
Aug 26, 2012
I am testing to find out that by using utl_file, if I finish reading all the entries in the file, then I encounter no_data_found, just want to make sure I get no data found when all entries in the file are read
SQL> create or replace directory my_docs as 'c:photos';
create or replace procedure myproc is
v_line VARCHAR2(2000); -- Data line read from input file
v_file UTL_FILE.FILE_TYPE; -- Data file handle
v_dir VARCHAR2(250) := 'my_docs'; -- Directory containing the data file
[Code]....
/so I execute this procedure and I get
ERROR at line 1:
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 33
ORA-06512: at "SYS.UTL_FILE", line 436
ORA-06512: at "MYPROC", line 12
ORA-06512: at line 2
View 8 Replies
View Related
Nov 15, 2012
how change the default directory path from server to our local system directory in external table while loading the data from csv file to table actually my default directory 'abc'(installed oracle server directory) in external tables , now i want to change that default directory to my local(c:Sm(not installed oracle s/w)).
View 1 Replies
View Related
Apr 27, 2011
I need to call pdf file in oracle form 6i without specify the path of adobe acrobat reader. how to do that?
i.e.:
AppID := DDE.App_Begin(<path where you have winword.exe in your system> <path of the document you wish to open>,DDE.APP_MODE_NORMAL);
i dont need to write ths part
<path where you have winword.exe in your system>
that because in our company we have several virgins of acrobat reader and i really need to call pdf file and make the call statement public
View 4 Replies
View Related
Aug 10, 2011
How to call a batch file existing in network path through oracle forms 6i. I am using following code in Forms 6i which is supposed to FTP some .text files to a UNIX box.
Host( '\guww.netdfs.root.Global Shared Data$(LEV)Leven Shared DataLeven Shared DataPublicCOMMONMatsEmpty Bottle ReportsSchedules Preliminaryftp_files_to_ddd.bat');
When I am running this batch file ftp_files_to_ddd.bat from local directory of my PC,it is working properly.
View 1 Replies
View Related
Oct 3, 2013
I write a file on database server by following
CREATE OR REPLACE DIRECTORY TEST_DIR AS 'c: emp'
GRANT READ, WRITE ON DIRECTORY TEST_DIR TO myuser
SQL> select * from all_directories;
OWNER DIRECTORY_NAME
------------------------------ ---------------------
DIRECTORY_PATH
----------------------------------------------------
SYS TEST_DIR
c: emp
SYS PUBLIC_DIR
E:PUBLIC_dir
and then
PROCEDURE run_query(p_sql IN VARCHAR2
,p_dir IN VARCHAR2
,p_header_file IN VARCHAR2
,p_data_file IN VARCHAR2 := NULL) IS
[code]...
but I get error wut_118.
View 1 Replies
View Related
May 25, 2010
Is there anyway to get a listing of the files in a specified directory on an ftp server using webutil?
View 2 Replies
View Related
Sep 20, 2012
How can i print a report name with full path at left bottom on report.
View 3 Replies
View Related
Oct 31, 2011
how do i copy an image or a text file from ex: directory c to directory d
View 5 Replies
View Related
Feb 6, 2011
I am working on oracle 10g with developer 2000 . I have a problem while running reports. when i run a report it goes to a particular path in which my database are not there and hence gives a error 'cannot find server'. everytime i have to physically change the path of the database to run the report.
THE PATH WHERE MY APPLICATION AND THE IP ADDRESS OF WINDOWS SYSTEM IS THIS
[URL]...
WHERE AS THE REPORT TAKES ME TO THIS PATH
[URL]...
I had a look at the reports conf file , but couldnt find the path of the database which the report shows for me to change it. It looks like some where the report path has been hardcoded but i am not able to locate it.
There might be some link missing while installing the application and the database.
View 1 Replies
View Related
Dec 12, 2012
How to get the file name from directory without Java. Is there any way to do it in Pl/Sql.
View 13 Replies
View Related
Apr 10, 2009
How do I handle spaces in the path name of a file with PL/SQL? This is what I am trying to do.
start f:folder namefolder name with spacesfoldernamescript.sql
I keep getting an error:
"The file 'f:folder.sql' does not exist."
Is there a special character I need to put in there for the spaces? How can I get this to work?
View 3 Replies
View Related
Oct 4, 2013
We upload a file on our library on weekly basis. I wanted to fetch the latest uploaded file path/URL from a folder through PL/SQL, but not sure if it's possible.
View 12 Replies
View Related
Oct 29, 2012
I have created report with the collections. Report query has been changing dynamically but i got problem with report header names and headers names has not been changing dynamically it is always showing like c001,c002....etc so, i have created global item(G_ITEM) in shared components--->Applications items after that I have created process(before headers) and assigning some value to G_ITEM and used &G_ITEM to column headres in IR Report but here &G_ITEM is not showing any value.
How can i achieve dynamic headers names by using *&G_ITEM(global items)*
View 1 Replies
View Related
Oct 7, 2009
have a log file in unix server under(/usr/home/oraj/log/abc.log) I am trying to access from oracle stored procedure as fallows
src_clob BFILE := BFILENAME('/usr/home/oraj/log', 'abc.log');
Exception:
ERROR at line 1:
ORA-22285: non-existent directory or file for FILEOPEN operation
ORA-06512: at "SYS.DBMS_LOB", line 716
ORA-06512: at "usr.LOAD_CLOB_FROM_XML_FILE", line 39
ORA-06512: at line 1
I dont want to create directory as such ('/usr/home/oraj/log') as it is already exists and all log files sits there.
CREATE OR REPLACE PROCEDURE Load_CLOB_From_XML_File
IS
dest_clob CLOB;
src_clob BFILE := BFILENAME('/usr/home/oraj/log/', 'abc.log');
dst_offset number := 1 ;
src_offset number := 1 ;
[code]...
View 1 Replies
View Related
Feb 17, 2012
This generates a CSV file in an directory. When it runs for the 1st time it take SYSDATE -7 data. After the 1st run it appends the data since the last run. Now my problem is the appending happens at the bottom of the file and every time the header appears. I want the header only the first time and the new data should keep appending at the top so that i get the latest data always at the top.
View 18 Replies
View Related
Jan 6, 2013
I have an issue when I enable auditing feature in oracle,I use 'DB' to store the audit from user in oracle, my command is
SQL>alter system set audit_trail=db scope=spfile;
SQL>shutdown immediate;
SQL>startup;
in show parameter audit, I see that the audit_trail already changed to DB after I create a user and enable audit for this user, I can see in the audit table dba_audit_trail for insert, update, delete,etc but If I am not wrong, if I using DB to setting the audit parameter then I will get audit file both in oracle table and in adump oracle folder installation, but in my case I cannot find any file in adump directory.
my operating system is windows7 and I use oracle database 10g express edition
View 8 Replies
View Related
Apr 7, 2011
I am using Forms / Reports Developer Version 6. When I run the report through form the Report runs but updated file was not executed. The path from which I run report through form contains updated report name. When I run report by using Report runtime shortcut then updated report will run. The report path mention in form using run_product also contains the updated file but didn't execute the updated file.
View 1 Replies
View Related
Jul 12, 2012
I need to copy .CSV File from a Windows Server shared path (\hostnameoutput) to another server which i believe is on unix.The other server name is abc.hcl.com. On this server i need to put it in the root directory. I will have to use SFTP and not FTP.
View 19 Replies
View Related
Jun 17, 2010
This is the error message iam getting when trying to open EM... Im new to DBA and also to this DB....
[sandeep@Linux4 ~]$ emctl start dbconsole
TZ set to US/Eastern
Unable to locate file /home/sandeep/oracle/product/10.2.0/db_1/Linux4.localdomain.com_orcl/sysman/config/emd.properties : No such file or directory
View 16 Replies
View Related
Jun 7, 2013
i have one directory in this directory contains 100 file these files are related to table structured creation with dependence
so how to read file names from directory and executed in scheme with logs also
procedure or script
View 5 Replies
View Related
Nov 28, 2012
using pl/sql code i am creating text file on specific path of database server. i need to compress this file .how to compress the text file using pl/sql?
View 1 Replies
View Related
Jul 6, 2012
I noticed that listener file in diag/trace is rapidly increasing. I am using 11g Rel 1 on window 2008 server Its 1 GB in couple of days. Is there any way if I can turn it off ?
View 5 Replies
View Related
Apr 28, 2011
I am trying to import the database and i see the following error:
IMP-00051: Direct path exported dump file contains illegal column length imp abruptly stops. my source and destination database is as follows:
Source: 9.2.0.8
Destinatin: 11g-r2.
I used exp with the following options:
direct=y
buffer=899989898
recordlength=64000
File=1.dmp,2.dmp,3.dmp,4.dmp,5.dmp,6.dmp,7.dmp,8.dmp,9.dmp,10.dmp,11.dmp,12.dmp,
13.dmp,14.dmp,15.dmp,16.dmp,17.dmp,18.dmp,19.dmp,20.dmp,21.dmp,22.dmp,23.dmp,24.
dmp,25.dmp,26.dmp,27.dmp,28.dmp,29.dmp,30.dmp
grants=y
compress=y
FILESIZE=25g
owner=BRM
Using imp with the following option:
indexes=n
buffer=99989898
recordlength=64000
File=1.dmp,2.dmp,3.dmp,4.dmp,5.dmp,6.dmp,7.dmp,8.dmp,9.dmp,10.dmp,11.dmp,12.dmp,
13.dmp,14.dmp,15.dmp,16.dmp,17.dmp,18.dmp,19.dmp,
20.dmp,21.dmp,22.dmp,23.dmp,24.dmp,25.dmp,26.dmp,27.dmp,28.dmp,29.dmp,30.dmp
analyze=n
grants=y
fromuser=brm
touser=brm
statistics=none
why my imp failing?
View 4 Replies
View Related