Results for BFILENAME


1 to 20 of 54 results. Prev  Next
Results per page:   20  | 40


SQL Reference, 10g Release 1 (10.1)

BFILENAME

BFILENAMESyntax bfilename::= Description of the illustration bfilename.gif Purpose BFILENAME returns a BFILE … them as arguments to BFILENAME in a SQL or PL/SQL statement, DBMS_LOB package, or OCI operation. You … case and a quoted identifier in the CREATE DIRECTORY statement, then when using the BFILENAME … example inserts

Application Developer's Guide - Large Objects, 10g Release 1 (10.1)

4 LOBs in Tables

Initializing BFILEs to NULL or a File NameA BFILE can be initialized to NULL or to a filename. To do so, you can use the BFILENAME() function. See Also: "BFILENAME() and Initialization".

Programmer's Guide, 10g Release 1 (10.1)

7 LOB and BFILE Operations

Associating a BFILE in a Table with an Operating System FileThe BFILENAME() function can be used in an INSERT statement to associate an external server-side … (operating system) file with a BFILE column/attribute in a table. Using BFILENAME() in an UPDATE … . OCILobFileSetName() can also be used to associate a BFILE in a table with an operating system file. BFILENAME() is … Objects for

Developer's Guide, 10g Release 1 (10.1)

4 XMLType Operations

Selecting XML Data Using XMLType Member FunctionsVALUES ( xmltype ( bfilename('XMLDIR','purchaseOrder.xml'), nls_charset_id('AL32UTF8') ) ); 1 row … ', xmltype ( bfilename('XMLDIR','purchaseOrder.xml'), nls_charset_id('AL32UTF8') ) ); 1 row created

Pro*COBOL® Programmer's Guide, 10g Release 1 (10.1)

13 Large Objects (LOBs)

13.2 How to Use LOBsFILEEXISTS() DESCRIBE FILEGETNAME() DESCRIBE FILEISOPEN() DESCRIBE FILEOPEN() OPEN BFILENAME() FILE SET … () WRITE Footnote  1  From dbmslob.sql. All routines are prefixed with 'DBMS_LOB.' except BFILENAME … . Footnote  2  The BFILENAME() built in SQL function may also be used. Note: You must explicitly lock the

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

16 Large Objects (LOBs)

16.2.1 Three Ways to Access LOBsOCILobFileOpen FILEOPEN() OPEN OCILobFileSetName BFILENAME() FILE SET Foot  3  OCILobFlushBuffer - FLUSH … with 'DBMS_LOB.' except BFILENAME. Footnote  3  T he BFILENAME() built in SQL function may also be

Reference, 10g Release 1 (10.1)

Static Methods Unique to the ORDImage Object Type Relational Interface

imageBfileinformation for known image attributes: DECLARE img_attrib CLOB; data BFILE:= BFILENAME('IMAGEDIR

Pro*COBOL® Programmer's Guide, 10g Release 1 (10.1)

13 Large Objects (LOBs)

13.2.2 Initializing a LOB… Alternatively, you can use the BFILENAME('directory', 'filename') function in an INSERT or UPDATE statement to … physical directory and filename: EXEC SQL INSERT INTO file_table (a_bfile) VALUES (BFILENAME('lob_dir … ', 'image.gif')) RETURNING a_bfile INTO:A-BFILE END-EXEC. Note: BFILENAME() does not check permissions on

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

16 Large Objects (LOBs)

16.2.3 Initializing a LOBthe BFILENAME('directory', 'filename') function in an INSERT or UPDATE statement to initialize a … filename: EXEC SQL INSERT INTO file_table (a_bfile) VALUES (BFILENAME('lob_dir', 'image.gif … ')) RETURNING a_bfile INTO:bfile. Note: BFILENAME() does not check permissions on the directory or filename

Developer's Guide, 10g Release 1 (10.1)

3 Using Oracle XML DB

Accessing Oracle XML DB Repository Programmatically', bfilename('XMLDIR','DocExample01.txt'), nls_charset_id('AL32UTF8')); end; / PL/SQL procedure successfully completed.

Packages and Types Reference, 10g Release 1 (10.1)

45 DBMS_LOB

Security ModelBFILENAME function in the Oracle Database Application Developer's Guide - Large Objects and the

Developer's Guide, 10g Release 1 (10.1)

3 Using Oracle XML DB

Loading XML Documents into Oracle XML DB Repository; begin res:= dbms_xdb.createResource('/home/SCOTT/purchaseOrder.xml', bfilename('XMLDIR

Developer's Guide, 10g Release 1 (10.1)

2 Features of OraOLEDB

LOB Support, topomap) VALUES (158, BFILENAME('mapdir', 'topo158.tps')) For more information on LOBs, see Oracle Database Application Developer's Guide - Large Objects.

Reference, 10g Release 1 (10.1)

SI_StillImage Object Type

content; fils BFILE:= BFILENAME('FILE_DIR','keyboard.jpg'); myimage SI_StillImage; BEGIN -- Put the blob in … SI_ChgContent( ) procedure: DECLARE newcontent BLOB; fils BFILE:= BFILENAME('FILE_DIR','keyboard.jpg

JDBC Developer's Guide and Reference, 10g Release 1 (10.1)

14 Working with LOBs and BFILEs

14.6.3 Creating and Populating a BFILE Columncolumn, use the bfilename function to specify the directory alias and the name of the BFILE file … . cmd ="INSERT INTO my_bfile_table VALUES ('one', bfilename(test_dir, 'file1.data'))"; stmt.execute … (cmd); cmd ="INSERT INTO my_bfile_table VALUES ('two', bfilename(test_dir, 'jdbcTest.data

Developer's Guide, 10g Release 1 (10.1)

3 Using Oracle XML DB

Using SQL Constraints to Enforce Referential IntegrityINTO PURCHASEORDER VALUES ( xmltype ( bfilename('XMLDIR','InvalidReference.xml'), nls_charset_id … ); Table altered. -- INSERT INTO PURCHASEORDER VALUES ( xmltype ( bfilename('XMLDIR','purchaseOrder.xml … ( bfilename('XMLDIR','DuplicateReference.xml'), nls_charset_id('AL32UTF8') ) ); INSERT INTO PURCHASEORDER … PURCHASEORDER VALUES

Reference, 10g Release 1 (10.1)

Static Methods Unique to the ORDVideo Object Type Relational Interface

ctx; ctx RAW(64):=NULL; vid_data BFILE:= BFILENAME('VIDEODIR','testvid.dat'); vid_format VARCHAR2(160

Reference, 10g Release 1 (10.1)

Static Methods Unique to the ORDImage Object Type Relational Interface

imageBfile32 pixels in the destination image: DECLARE dest_attrib CLOB; image_data BFILE:= BFILENAME('IMAGEDIR

Reference, 10g Release 1 (10.1)

Static Methods Unique to the ORDImage Object Type Relational Interface

imageBfileimg_data BFILE:= BFILENAME('IMAGEDIR','testimg.dat'); img_attrib CLOB; mimeType VARCHAR2(80); width

Packages and Types Reference, 10g Release 1 (10.1)

45 DBMS_LOB

External LOBsDIRECTORY object and the filename of the external LOB you are adding to the BFILENAME function to





Was this page helpful?

Integrated Cloud Applications & Platform Services