BANNER
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Prod
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production
/* Formatted on 2012/04/10 10:43 (Formatter Plus v4.8.8) */
CREATE OR REPLACE PACKAGE lobster
AS
/******************************************************************************
NAME: iblob
Automatically available Auto Replace Keywords:
Object Name: iblob
Date and Time: 10/04/2012, 10:07:35
Author: 1B
Version: 1.0
******************************************************************************/
TYPE t_csv_data IS RECORD (
v_no VARCHAR2 (10),
v_name VARCHAR2 (100)
);
TYPE csv_data_arr_t IS TABLE OF t_csv_data
INDEX BY BINARY_INTEGER;
PROCEDURE blob_2_clob (
v_blob_or_clob IN NUMBER,
v_blob IN OUT BLOB,
v_clob IN OUT CLOB,
v_amount IN OUT NUMBER,
v_blob_offset IN OUT NUMBER,
v_clob_offset IN OUT NUMBER,
v_lang_context IN OUT NUMBER,
v_warning OUT NUMBER
);
FUNCTION f_csv_data
RETURN csv_data_arr_t PIPELINED;
END lobster;
/
I try to compile using TOAD, unfortunately the result is Warning: 'compiled but with compilation errors'.
How to declare a PIPELINED function in a package?
Tx, in advance.