Can't figure out the simplest, two-line proc! [message #305746] |
Tue, 11 March 2008 18:31  |
radalapsker@yahoo.com
Messages: 3 Registered: March 2008
|
Junior Member |
|
|
Hello,
I have a proc that keeps giving me errors. I reduced it to 2 lines but still can't figure out the problem... can't be that hard but I just can't see what could possibly be wrong!
Package Specification
CREATE OR REPLACE PACKAGE TEST123 AS
PROCEDURE TEST1(xcursor OUT SYS_REFCURSOR, xstring OUT VARCHAR2);
END TEST123;
/
Package Body
CREATE OR REPLACE PACKAGE BODY TEST123 AS
PROCEDURE TEST1(xcursor OUT SYS_REFCURSOR, xstring OUT VARCHAR2)
AS BEGIN
open xcursor for SELECT 'one banana' as abc from dual;
xstring := 'yellow';
END TEST1;
END TEST123;
/
Error:
ORA-06550: line 1, column 29:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
. ( ) , * @ % & | = - + < / > at in is mod remainder not
range rem => .. <an exponent (**)> <> or != or ~= >= <= <>
and or like LIKE2_ LIKE4_ LIKEC_ as between from using ||
indicator multiset member SUBMULTISET_
The symbol ", was inserted before ";" to continue.
Any help is much appreciated!
|
|
|
|
|
|
|
|