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

["Happersberger. Rich (MSA)" <happersbergerr@SacCounty.NET>]

Actually the "table" is really a view created by the folks that did the
db design
A little out of my hands.

Datta already provided a simple fix.  Thanks again -

-----Original Message-----
From: the dragon [mailto:ceprn@hotmail.com] 
Sent: Wednesday, May 05, 2004 9:29 AM
To: sqr-users@sqrug.org
Cc: Happersberger. Rich (MSA)
Subject: RE: [sqr-users] (SQR 5528) Error


The :1 indicate values passed in the sql.  Your problem is probably in
yout 
subselect where you are selecting from a table called hv$sample_type  -
that 
is not a good name for the table, if you're actually calling a table
that.  
More likely it's a typing mistake.  Also, there is no need to use the 
underscore variable outside a local procedure.

peace,
clark 'the dragon' willis



PSA: Salary <> Slavery.  If you earn a salary, your employer is renting
your 
services for 40 hours a week, not purchasing your soul.  Your time is
the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

"Time is the coin of your life. It is the only coin you have, and only
you 
can determine how it will be spent.  Be careful lest you let other
people 
spend it for you."

Carl Sandburg
(1878 - 1967)

----Original Message Follows----


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