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

Forms :: How To Find File Path Dynamically

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

Forms :: Error While Running Report - File Not Dynamically Attached

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

SQL & PL/SQL :: Retrieve The Path Of A Directory

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

SQL & PL/SQL :: ORA-29280 / Invalid Directory Path

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

PL/SQL :: ORA-29280 / Invalid Directory Path

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

PL/SQL :: Error / ORA-29280 / Invalid Directory Path

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

PL/SQL :: Utl_file  ORA-29280 - Invalid Directory Path

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

SQL & PL/SQL :: Change External Directory From Server To Local Machine Path

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

Forms :: Call PDF File Without Specifying Reader Path?

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

Forms :: How To Call Batch File Existing In Network Path Through 6i

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

Forms :: File Transfer From Server Directory To Client?

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

Forms :: Webutil File Transfer Directory Listing

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

Reports & Discoverer :: How To Print A Report Name With Full Path At Left Bottom On Report

Sep 20, 2012

How can i print a report name with full path at left bottom on report.

View 3 Replies View Related

Forms :: Copy Image Or Text File From Source Directory To Destination

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

Oracle 10g With Developer 2000 - Report Path?

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

SQL & PL/SQL :: How To Get The File Name From Directory

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

How To Handle Spaces In Path Name Of File With PL/SQL

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

SQL & PL/SQL :: Fetch File Path From A Folder

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

Application Express :: How To Change Column Header Value Dynamically In IR Report

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

Accessing File From Directory?

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

SQL & PL/SQL :: Generates CSV File In Directory

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

There Is No File Audit In Adump Directory

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

Forms :: Report Through Form - Updated File Not Executed

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

SQL & PL/SQL :: Copy CSV File From Windows Server Shared Path

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

Enterprise Manager :: Setup - No Such File Or Directory

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

PL/SQL :: Directory List - How To Read File Names

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

SQL & PL/SQL :: Creating Text File On Specific Path Of Database Server?

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

Listener File Rapidly Increasing In Diag Directory Of 11g

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

Direct Path Exported Dump File Contains Illegal Column Length

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







Copyrights 2005-15 www.BigResource.com, All rights reserved