remove ; after PROCEDURE AreaSelect ( cur_AreaSelect out T_CURSOR); add ; after END select_areaselect;
On Wed, Apr 14, 2010 at 12:51 AM, rastau < rainer.g...@external.thalesgroup.com> wrote: > 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 Oracle-PLSQL@googlegroups.com > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@googlegroups.com > 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. > -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
