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

["Alexander, Steve" <Steven.Alexander@sanjoseca.gov>]

When you write a select statement with a clause like:

where ... sc.queue = $queue ...

SQR send a SQL statement to Oracle using bind variables.  That means the
statement has a "sc.queue=:1" clause, and separately there is the first bind
variable with the value of $queue.  This is more efficient if you execute
the select statement again with another value of $queue.  Your error message
might be due to the comma between the keyword DISTINCT and the first column
name.

-----Original Message-----
From: Happersberger. Rich (MSA) [mailto:happersbergerr@SacCounty.NET]
Sent: Wednesday, May 05, 2004 8:45 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] (SQR 5528) Error



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

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