Re: Returning a REF cursor

<franmerar229_at_gmail.com> a écrit dans le message de news: bbbe29aa-a04a-4650-846f-2ce9aa05fa51_at_googlegroups.com...
| Something like this:
|
| 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!!

Any feedback? Received on Thu Aug 04 2016 - 17:28:27 CEST