Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PIPELINED

indra budianthoApr 9 2012 — edited Apr 10 2012
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.
This post has been answered by prakash on Apr 10 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 8 2012
Added on Apr 9 2012
6 comments
875 views