Stack Overflow
Stack Overflow

Questions tagged [bfile]

13 questions
1
vote
0 answers

Unable to Update/Insert Oracle Bfiles - Read Only

I have Bfile filed in ORACLE db. While inserting data it is throwing following error Unable to Update/Insert Oracle Bfiles - Read Only Two days before same setup was working for last 6 months. We have created bfile directory on shared path and same…
user3008692
  • 39
  • 1
  • 6
0
votes
0 answers

oracle.sql.BFILE cannot be cast to oracle.sql.BFILE

After reading one and once again oracle's documentation and not sure why I having this exception Caused by: java.lang.ClassCastException: oracle.sql.BFILE cannot be cast to oracle.sql.BFILE @Inject @OracleProduction private EntityManager…
jthmiranda
  • 73
  • 1
  • 7
0
votes
0 answers

Overide a BFILE in unit test Quarkus to use H2

I'm confronted with legacy code using an oracle BFILE. In other applications I successfully used the really powerful rider-cdi test annotations in combination with quarkus-jdbc-h2. I like to continue that strategy. However the BFILE is spoiling…
Sjaak
  • 3,602
  • 17
  • 29
0
votes
1 answer

Oracle BFILE cand Directory: Error message

I am not very experienced with Oracle and BFILEs, so I apologize if the answer to my question is very obvious. I am using Oracle SQL Developer and Oracle Database 12c Enterprise Edition. I try to save images externally via BFILE. For this I created…
SQL_User
  • 1
  • 1
0
votes
1 answer

Can i use a BFILENAME within a cursor for multiple images?

Is it possible to concatenate the .jpg filename in order to upload several images to a table? I want it to do it with a cursor. Here is the code: CREATE OR REPLACE PROCEDURE upload_pics AS CURSOR c_id IS SELECT DISTINCT id_pic FROM…
Entretekno
  • 1
  • 1
0
votes
2 answers

display the content of a file split by a delimiter character

I am trying to display the content of a file, split by a delimiter character. More exactly, starting from this topic, I am trying to display the result as: bbb aaa qqq ccc but the data source to be taken from a file. Until now, I…
mikcutu
  • 1,013
  • 2
  • 17
  • 34
0
votes
1 answer

cannot insert oracle bfile datatype column from remote client

As the definition of bfile : A BFILE is a data type used to store a locator (link) to an external binary file (file stored outside of the database). To associate an operating system (OS) file to a BFILE, we need to create a DIRECTORY object which…
Sandi
  • 61
  • 3
0
votes
1 answer

loading bfile via SQL Loader

I am trying to load values into a table who's one of the columns is BFILE using SQL Loader. My table looks like this: create table documents ( id number primary key , text bfile) Here are my CTL adn DAT files: loader.ctl load data infile…
mikcutu
  • 1,013
  • 2
  • 17
  • 34
0
votes
1 answer

metadata of a BFILE

Is there any way, working with BFILEs, to collect the metadata information? In my case, I have a table who's one of the columns is BFILE and points towards a location from the hard drive where I have text file(PDF, DOC, DOCX, TXT, HTML, etc.) For…
mikcutu
  • 1,013
  • 2
  • 17
  • 34
0
votes
0 answers

Blob storage for both SQL Server and Oracle

I have an application currently working on the SQL Server 2012 and Microsoft stack. I have a lot of images and documents which are required to be versioned and stored. Since the database was SQL Server, I was using Filetable & Filestream for…
Sharath Chandra
  • 654
  • 8
  • 26
0
votes
0 answers

How to get text from pdf preserving original formatting (with CTX_DOC)?

I use this code to filter text from pdf file: create or replace directory pdf_dir as '&1'; create or replace directory l_curr_dir as '&3'; declare ll_clob CLOB; l_bfile BFILE; l_filename VARCHAR2(200) := '&2'; begin begin …
pradeep
  • 7
  • 6
0
votes
2 answers

oracle.jdbc.driver.T4CConnection cannot be cast to oracle.jdbc.OracleConnection in JBOSS EAP 6.1

I have deployed my ear in JBOSS 7.1.1 AS. For viewing the document in application we are using the BFILE. Below code is used: Connection con = this.jdbcTemplate.getDataSource().getConnection(); con = unwrapConnection(con); if(null != con) { …
user3797766
  • 1
  • 1
  • 2
0
votes
1 answer

JDBC, Oracle SQL, adding and displaying picture on label

I have picture 'osta.jpg' on my desktop and I want to add this to my database Oracle SQL and then load this picture from database in Java application (JDBC) and show on label by a JLabel lblFilm = new JLabel(new ImageIcon( "picture_from_SQL") (Swing…
mac229
  • 4,319
  • 5
  • 18
  • 24