Home > Default > About utl_file

About utl_file

November 30Hits:0
Advertisement
Hi,
I have one excel file as follows;
Insured               Policy #     Attn to               Fax
Spring Industries, Inc. WC-000008-03     Juengermann, Allen      (805) 644-1842
I want read only policy # from this file to check the policy number is exists in table or not.
If some body worked on this then please help me.
Thanks in advance.

Answers

You have the architecture the wrong way around. An Excel spreadsheet should be the client and not the server.
If the data in Excel is to be shared and used by a number of database users, then that spreadsheet must be moved from Excel into Oracle.
Excel is not a data server that can share spreadsheet data to a number of concurrent users. Oracle is.
If the spreadsheet data is not a "multi-user data set", then Excel is indeed the client. A client that wants to check whether the policy # exist in the database.
In this case you need to write an Excel macro (using VB for Applications?) that opens an ODBC connection to the Oracle server and run a SQL (with bind variables) to determine if the server knows about that policy or not.
UTL_FILE has no role to play in any of this.

Read other 7 answers

Tags:

Related Articles

  • Help needed in utl_fileOctober 11

    Hi, I have two groups in data model of my report. I am using utl_file in a formula column of report last group.it's working fine. but my problem is if customer has more than one invoice lines then all that lines not comes under only particular custom

  • Problems with moving files to ora directory UTL_FILE.PUT_RAW - ORA-29285October 11

    hi, i'm using apex 4.1 i have a procedure which moves my file from apex_application_files to ORA directory. if i choose a text file or small word document which is 1kb, it works. but if i have pdf file (85kb) or word document (16kb) it gives me ORA-2

  • (ORA-06508: PL/SQL: could not find program unit being called) utl_fileOctober 11

    hi all, I am using Oracle XE and forms 6i and am facing the above error when i try to use the utl_file utility. WHEN BUTTOn PRESSED      IF (:EXPORT_IMPORT_DATA = 'E') THEN           message(lc_status);                          SECURITY.PKG_gen_trnsf

  • How to create/delete files from filesystem using PL/SQL ? UTL_FILE?October 11

    Greetings, I will start by explaining what i intend to do. I have an application made in APEX. This application will have among other purposes the managment of pdf files which will reside in the filesystem. I have questioned the person in charge to k

  • Problem with UTL_FILE (please see my last post on this thread)October 11

    Hi all, I'm trying to get the code (procedures, functions, etc) of my schemas. I've tried it using DBMS_METADATA.GET_DDL but it fails with many objects. Finally, I'm trying to create a procedure to extract the code. I've created this two procedures:

  • Line size in UTL_FILEOctober 11

    Hi, Can someone please tell me what is the max. number of characters that can be written using UTL_FILE in Oracle 8.1.7?Perhaps I should have been more specific; I wanted to know how many characters can PUT_LINE or PUT function take at one time to wr

  • Producing text file from PL/SQL procedure (UTL_FILE)?October 11

    Hi, I need to produce a text file from a PL/SQL procedure. My output should be a little over 38K records and my query has 70 fields. I'd like to separate the fields by pipe delimiters in the text file. I can either concatenate all 70 fields into one

  • How do I use UTL_FILE to insert a large number of fields to a file?October 11

    Hi I am trying to use UTL_FILE for the first time in a Stored Procedure. I need to run a complex query to select 50 fields from various tables. I need these to be inserted into one line in the output file for all rows. Is this possible? My procedure

  • How to read a specific value or a portion of text using utl_file.October 11

    hi, I have a small requirement which goes as follows. I have a text file which is a resultof the sql query and it contains 16 columns as PIPE delimited text . I am using the UTL_FILE package concept to read the data. In general when we use the UTL_FI

  • How to read a tab seperated data from a text file using utl_fileOctober 11

    Hi, How to read a tab seperated data from a text file using utl_file... I know if we use UTL_FILE.get_line we can read the whole line...but i need to read the tab separated value separately..... Thanks in advance... NaveenNaveen Nishad wrote: How to

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.561 s.