Problem with Cursor-Please help!
Date: Wed, 2 Jan 2002 11:29:37 -0500
Message-ID: <a0vchj$3pb_at_ftp.ee.vill.edu>
Hi,
[Quoted] I am having a weird problem with an SQL I am trying to use as a cursor. Here is the SQL:
[Quoted] select * from group_at_ruat t1
where nvl(trunc(update_date),trunc(sysdate))>
decode((select trunc(upd_date) from process_track where upper(ltrim(rtrim(table_name)))='GROUP' and id=t1.quest_group),null,trunc(sysdate))
The problem is that this runs fine if I run it from the SQL prompt and returns me data, but if I put it as a cursor, I get the following error messages:
PLS-00103: Encountered the symbol "SELECT" when expecting one of
the following:
( - + mod not null others <an identifier>
<a double-quoted delimited-identifier> <a bind variable> avg
count current exists max min prior sql stddev sum variance
execute forall time timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string>
PLS-00103: Encountered the symbol "," when expecting one of the following: ;
The SELECT mentioned in the above error message is the select in the 3rd line of my SQL statement. The second error message refers to the first "," [Quoted] in the last line. I've been trying to fix this for the last couple of days, [Quoted] but couldn't do it. Can anyone point me to where am doing this wrong?
Thanks for your help.
-Raj Received on Wed Jan 02 2002 - 17:29:37 CET