Re: A very very basic PL/SQL question from a newbie

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Wed, 15 Sep 1999 09:22:29 +0200
Message-ID: <7rnhgu$nt$1@oceanite.cybercable.fr>

min is a reserved word for the group function min. You have to double-quote it:

DECLARE

     CURSOR weblog_cur IS
     SELECT hr,"MIN",sec,filetype
       FROM weblogq ORDER BY sequence;
     CURSOR weblog_cur_dis IS
     SELECT dis_ftype from dis_ft ORDER BY sequence;
v_hr weblogq.hr%TYPE;
v_min weblogq."MIN"%TYPE;
v_sec weblogq.sec%TYPE;

v_filetype weblogq.filetype%TYPE;
v_disft dis_ftype%TYPE;
...

sxbktm_at_my-deja.com a écrit dans le message <7rmksm$9jn$1_at_nnrp1.deja.com>...
>All I am trying to do is declare two cursors and fetch numeric values
>into the cursor. Any time I do this, I get message saying
>
> Encountered the symbol "," when expecting one of the following: (.
>
>
>But when I am using varchars, I don't get this problem.
>
> DECLARE
> CURSOR weblog_cur IS
> SELECT hr,min,sec,filetype
> FROM weblogq ORDER BY sequence;
> CURSOR weblog_cur_dis IS
> SELECT dis_ftype from dis_ft ORDER BY sequence;
> v_hr weblogq.hr%TYPE;
> v_min weblogq.min%TYPE;
> v_sec weblogq.sec%TYPE;
> v_filetype weblogq.filetype%TYPE;
> v_disft dis_ftype%TYPE;
>
>-------------
>
>Could you help me resolve this issue. Thanks in advance.
>
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Wed Sep 15 1999 - 02:22:29 CDT