Hi everyone,
I get an error message in line 3 :
PLS-00103: Fand das Symbol "AS" als eines der folgenden erwartet
wurde:
begin end function package pragma procedure subtype type use
I want to write a procedure for a select query. Could somebody help
me?
my code:
CREATE OR REPLACE PACKAGE BODY Select_AreaSelect AS TYPE T_CURSOR IS
REF CURSOR;
PROCEDURE AreaSelect ( cur_AreaSelect out T_CURSOR);
AS
BEGIN
OPEN cur_AreaSelect FOR
SELECT 'AreaName', 'pk_Areas_AreaID'
FROM "Areas";
END AreaSelect;
END Select_AreaSelect;
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
To unsubscribe, reply using "remove me" as the subject.
