Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Trying to write first package

Re: Trying to write first package

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Mon, 4 Oct 2004 19:29:55 +0200
Message-ID: <cjs1aj$b11$1@nntp.fujitsu-siemens.com>

"pcmodeler" <mark.fergel_at_bankofamerica.com> schrieb im Newsbeitrag news:3e2d808a.0410040928.75e2c998_at_posting.google.com...
> I'm new to Oracle. Trying to write my first package and I keep
> getting an error stating that it doesn't like the Create statement on
> line 6. Even removing it creates an error. I don't fully understand
> cursors yet, so that probably has somethign to do with it, but
> according to my documentation, it should be correct.
>
> CREATE OR REPLACE PACKAGE PG_TEST AS
> TYPE cdcur IS REF CURSOR;
> PROCEDURE SP_TEST
> (CRSE_CD IN OUT cdcur);
> END PG_TEST;

a / is missing here I think.

log
Volker Received on Mon Oct 04 2004 - 12:29:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US