Re: [sqr-users] (SQR 5528) Error

[Dattatraya Shetty <datta_shetty@yahoo.com>]

Hi Rich,

   Move the Distinct to be on the Same line as BEGIN-SELECT. The SQR is
Parsing it as Column and distinct is a Reserved word in ORACLE. 

   Moving it Up on the BEGIN-SELECT should do the trick. 
HTH
Datta. 

--- "Happersberger. Rich (MSA)" <happersbergerr@SacCounty.NET> wrote:
> 
> Hello -
> 
> I'm new to SQR, so hope to ask the correct questions -
> 
> Curious about the entries in the message below when it says
> "sc.queue=:1", etc.
> Does this indicate a collision of variables?
> 
> This query is part of a local procedure.
> 
> If the variables are hardcoded, this query will return stuff via
> SQLPlus.
> 
> From the following Select I get the following error;
> 
> (SQR 5528) ORACLE OCIStmtExecute error 936 in cursor 5:
>    ORA-00936: missing expression
> SQL:  SELECT DISTINCT, bs.sample_type, bs.schedule_seq  FROM
> batch_schedules
>       bs, schedules sc, project_samples ps WHERE
> sc.schedule_id=ps.hsn
> and
>       sc.queue=:1 and sc.queue=bs.queue and bs.batch_number=:2 and
>       ps.project_seq=:3 and bs.sample_type IN (select sample_type
> from
>       hv$sample_type where sample_type_flag NOT IN ('0','9') )
> 
> Error on line 227:
>    (SQR 3716) Error in SQL statement.
> 
> begin-select
> 
> DISTINCT
> bs.sample_type                   
> bs.schedule_seq                  
> 
> FROM
> batch_schedules bs,
> schedules sc,
> project_samples ps
> 
> WHERE
> sc.schedule_id=ps.hsn
> and sc.queue=$_bs.Queue
> and sc.queue=bs.queue                            !LACH for test
> purposes
> and bs.batch_number=$_bs.BatchNumber               !1963 for test
> purposes
> and ps.project_seq=#_ProjectSeq                 !14666 for test
> purposes
> and bs.sample_type IN
> (select sample_type
> from hv$sample_type
> where sample_type_flag NOT IN ('0','9')
> )
> 
> end-select
> 
> Thanks to all -
> 
> Rich Happersberger
> Asst. Systems Administrator
> SRCSD Laboratory (MSA)
> 
> 
> 
>
___________________________________________________________________________________________________________
> This email and any attachments thereto may contain private,
> confidential, and privileged material for the
> sole use of the intended recipient. Any review, copying, or
> distribution of this email (or any attachments
> thereto) by other than the County of Sacramento or the intended
> recipient is strictly prohibited.
> 
> If you are not the intended recipient, please contact the sender
> immediately and permanently
> delete the original and any copies of this email and any attachments
> thereto.
>
___________________________________________________________________________________________________________
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users



        
                
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs  
http://hotjobs.sweepstakes.yahoo.com/careermakeover 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users