建站
咨詢
售后
建站咨詢
新聞中心
這里有您想知道的互聯(lián)網(wǎng)營(yíng)銷解決方案
Oracle數(shù)據(jù)庫如何正確用PL/SQL？
以下的文章主要介紹的是Oracle數(shù)據(jù)庫如何正確用PL/SQL從相關(guān)數(shù)據(jù)庫中來準(zhǔn)確的讀取BLOB字段的實(shí)際操作，其中包括如何正確的確認(rèn)相關(guān)對(duì)象存在，以及如何創(chuàng)建存儲(chǔ)Directory等相關(guān)內(nèi)容介紹。
我們提供的服務(wù)有：成都網(wǎng)站建設(shè)、網(wǎng)站制作、微信公眾號(hào)開發(fā)、網(wǎng)站優(yōu)化、網(wǎng)站認(rèn)證、昌都ssl等。為上千余家企事業(yè)單位解決了網(wǎng)站和推廣的問題。提供周到的售前咨詢和貼心的售后服務(wù)，是有科學(xué)管理、有技術(shù)的昌都網(wǎng)站制作公司
1.確認(rèn)對(duì)象存在
- SQL> col fdesc for a30
- SQL> select fid,fname,fdesc from eygle_blob;
- FID FNAME FDESC
1 ShaoLin.jpg 少林寺-易經(jīng)經(jīng)
2 DaoYing.jpg 倒映
2.創(chuàng)建存儲(chǔ)Directory
- SQL> connect / as sysdba
- Connected.
- SQL> create or replace directory BLOBDIR as 'D:\oradata\Pic';
- Directory created.
- SQL>
- SQL> grant read,write on directory BLOBDIR to eygle;
- Grant succeeded.
- SQL>
3.Oracle數(shù)據(jù)庫用PL/SQL從數(shù)據(jù)庫中讀取BLOB字段的過程中我們需要?jiǎng)?chuàng)建存儲(chǔ)過程
- SQL> connect eygle/eygle
- Connected.
- SQL>
- SQL> CREATE OR REPLACE PROCEDURE eygle_dump_blob (piname varchar2,poname varchar2) IS
- l_file UTL_FILE.FILE_TYPE;
- l_buffer RAW(32767);
- l_amount BINARY_INTEGER := 32767;
- l_pos INTEGER := 1;
- l_blob BLOB;
- l_blob_len INTEGER;
- BEGIN
- SELECT FPIC
- INTO l_blob
- FROM eygle_blob
- WHERE FNAME = piname;
- l_blob_len := DBMS_LOB.GETLENGTH(l_blob);
- l_file := UTL_FILE.FOPEN('BLOBDIR',poname,'wb', 32767);
- WHILE l_pos < l_blob_len LOOP
- DBMS_LOB.READ (l_blob, l_amount, l_pos, l_buffer);
- UTL_FILE.PUT_RAW(l_file, l_buffer, TRUE);
- l_pos := l_pos + l_amount;
- END LOOP;
- UTL_FILE.FCLOSE(l_file);
- EXCEPTION
- WHEN OTHERS THEN
- IF UTL_FILE.IS_OPEN(l_file) THEN
- UTL_FILE.FCLOSE(l_file);
- END IF;
- RAISE;
- 31 END;
- 32 /
- Procedure created.
4.取出字段數(shù)據(jù)
- SQL> host ls -l d:\oradata\Pic
- total 7618
- -rwxrwxrwa 1 gqgai None 2131553 Apr 19 10:12 DaoYing.jpg
- -rwxrwxrwa 1 gqgai None 1768198 Apr 19 10:12 ShaoLin.jpg
- SQL> exec eygle_dump_blob('ShaoLin.jpg','01.jpg')
- PL/SQL procedure successfully completed.
- SQL> host ls -l d:\oradata\Pic
- total 11072
- -rwxrwxrwa 1 Administrators SYSTEM 1768198 Apr 26 07:16 01.jpg
- -rwxrwxrwa 1 gqgai None 2131553 Apr 19 10:12 DaoYing.jpg
- -rwxrwxrwa 1 gqgai None 1768198 Apr 19 10:12 ShaoLin.jpg
- SQL>
- SQL> exec eygle_dump_blob('DaoYing.jpg','02.jpg')
- PL/SQL procedure successfully completed.
- SQL> host ls -l d:\oradata\Pic
- total 15236
- -rwxrwxrwa 1 Administrators SYSTEM 1768198 Apr 26 07:16 01.jpg
- -rwxrwxrwa 1 Administrators SYSTEM 2131553 Apr 26 07:19 02.jpg
- -rwxrwxrwa 1 gqgai None 2131553 Apr 19 10:12 DaoYing.jpg
- -rwxrwxrwa 1 gqgai None 1768198 Apr 19 10:12 ShaoLin.jpg
上述的相關(guān)內(nèi)容就是對(duì)Oracle數(shù)據(jù)庫用PL/SQL從數(shù)據(jù)庫中讀取BLOB字段的描述，希望會(huì)給你帶來一些幫助在此方面。
網(wǎng)站題目：Oracle數(shù)據(jù)庫如何正確用PL/SQL？
網(wǎng)站路徑：http://www.dlmjj.cn/article/dphigdo.html
