create or replace procedure test(v_s integer)
as
v_CLOBlocator CLOB;
v_BLOBlocator BLOB;
BEGIN
-- Initializes the clob_col to the specified string, and returns the
-- locator into v_LOBlocator.
INSERT INTO lobdemo (key, clob_col)
VALUES (20, 'abcdefghijklmnopqrstuvwxyz')
RETURNING clob_col INTO v_CLOBlocator; -- Modifies blob_col for the same row.
UPDATE lobdemo
SET blob_col = HEXTORAW('00FF00FF00FF')
WHERE key = 20; -- Retrieves the locator for the newly updated value, not the value
-- itself.
SELECT blob_col
INTO v_BLOBlocator
FROM lobdemo
WHERE key = v_s;
END;
/
as
v_CLOBlocator CLOB;
v_BLOBlocator BLOB;
BEGIN
-- Initializes the clob_col to the specified string, and returns the
-- locator into v_LOBlocator.
INSERT INTO lobdemo (key, clob_col)
VALUES (20, 'abcdefghijklmnopqrstuvwxyz')
RETURNING clob_col INTO v_CLOBlocator; -- Modifies blob_col for the same row.
UPDATE lobdemo
SET blob_col = HEXTORAW('00FF00FF00FF')
WHERE key = 20; -- Retrieves the locator for the newly updated value, not the value
-- itself.
SELECT blob_col
INTO v_BLOBlocator
FROM lobdemo
WHERE key = v_s;
END;
/
解决方案 »
- 两表联合查询的存储过程怎么写?
- 关于 Power Synchronizer For Oralce
- oracle建表时能将几个字段建成一个联合项目吗?
- 怎样生成dml脚本
- Oracle 高级复制问题
- 求救:Oracle 存储过程运行不能结束!!导致Job死???
- 关于行转列 oracle的sql语句 很着急!!!!谢谢!
- 如何在红旗5.0上安装oracle 10g
- 如何对结果集进行统计
- 请交:我在asp中使用如下语句sql2="insert into szh values('检泵',24)"为什么在sql plus 中查询却是“??,24“,而在sql plus 中用该
- 求救:date类型的数据格式是什么?
- 一个有关返回特定行数的值得问题!急!在线等!
v_Buffer VARCHAR2(80);
v_Offset INTEGER := 1;
v_Amount INTEGER := 80;
BEGIN
LOOP
-- Read and output the next 80 characters.
DBMS_LOB.READ(p_CLOB, v_Amount, v_Offset, v_Buffer);
DBMS_OUTPUT.PUT_LINE(v_Buffer); v_Offset := v_Offset + v_Amount;
END LOOP;
EXCEPTION
WHEN NO_DATA_FOUND THEN
-- End of loop, just return.
NULL;
END LOBPrint;
/