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

Hi,

"MIN" is an Oracle reserved word.

greetings,
Thierry Poels
Oracle DBA & HP-UX Sysadmin

<sxbktm_at_my-deja.com> wrote in message news: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:21:11 CDT