[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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



Rich,

         Replace your SQL statement with the following SQL and give a try.


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


Hope this helps.

Krishna




-----Original Message-----
From: sqr-users-bounces+krishna.chennamaneni=jhuapl.edu@sqrug.org
[mailto:sqr-users-bounces+krishna.chennamaneni=jhuapl.edu@sqrug.org]On
Behalf Of Happersberger. Rich (MSA)
Sent: Wednesday, May 05, 2004 11: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
Here was a non admissible message part of 'application/ms-tnef' MIME
type. It has been automatically discarded before sending the message to
the list. 
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users