Re: Returning a REF cursor

From: <franmerar229_at_gmail.com>
Date: Tue, 2 Aug 2016 11:54:14 -0700 (PDT)
Message-ID: <bbbe29aa-a04a-4650-846f-2ce9aa05fa51_at_googlegroups.com>

[Quoted] Something like this:

[Quoted] CREATE OR REPLACE PACKAGE test_package AS

TYPE ref_crs IS REF CURSOR;

PROCEDURE test_procedure (

  p_score     NUMBER,
  p_email     VARCHAR2,
  p_address   VARCHAR2
  p_data  OUT REF_CRS);

END test_package;
/

Package created.

CREATE OR REPLACE PACKAGE BODY test_package AS

PROCEDURE test_procedure (

  p_score     NUMBER,
  p_email     VARCHAR2,
  p_address   VARCHAR2
  p_data  OUT REF_CRS) AS

BEGIN
  OPEN p_data FOR
    SELECT email FROM emails WHERE score = p_score; END test_procedure;

END test_package;
/

Then to call it:

var data refcursor;

exec test_package.test_procedure (
  p_score => 5,
  p_data => :data);

BEGIN test_package.test_procedure (; END;

                                   *

ERROR at line 1:
ORA-06550: line 1, column 36:
PLS-00103: Encountered the symbol ";" when expecting one of the following: ( ) - + case mod new not null <an identifier>

Any thoughts on this one?

Thanks!! Received on Tue Aug 02 2016 - 20:54:14 CEST