You are missing a single quote from the predicate - the quotes aren't
being fully escaped.

Change to

accountnumber=''''+@accno+''''

sam



-----Original Message-----
From: Shravan Kumar
[mailto:oracledba-ezmlmshield-x24328977.[Email address protected]
Sent: 31 July 2006 13:23
To: LazyDBA Discussion
Subject: error

when trying to insert a value into table tblpat_History, it is not
showing any error , but after when i see in table values are not getting
inserted ..
i found the error , it is taking only this part of sentence

insert into tblpat_History (Accountnumber,Patientis, DOA ,
HistoryOfIllness , PrevTheraphy , WorkSinceAccident) select
accountnumber, OSD_workType , OSD_DOA , OSD_Injury_Det ,
physTherapy_TimesperWK , OSD_StillWork from tblpodiatryprogress where
account


instead of the complete query::


set @qqqq = ' insert into tblpat_History (Accountnumber,Patientis, DOA ,
HistoryOfIllness , PrevTheraphy , WorkSinceAccident) '
set @qqqq = @qqqq+'select accountnumber, OSD_workType , OSD_DOA
, OSD_Injury_Det , physTherapy_TimesperWK , OSD_StillWork from
tblpodiatryprogress where accountnumber='''+@accno+''''
select @qqqq

where i hav given some account number say '100096'


CONFIDENTIALITY NOTICE: This e-mail and its attachments may contain
PRIVILEGED and CONFIDENTIAL INFORMATION and/or PROTECTED PATIENT HEALTH
INFORMATION intended solely for the use of Tranquilmoney Inc. it's
clients and the recipient(s) named above. If you are not the intended
recipient, or the employee or agent responsible for delivering this
message to the intended recipient, you are hereby notified that any
review, dissemination, distribution, printing, or copying of this e-mail
message and/or any attachments is strictly prohibited. If you have
received this transmission in error, please notify the sender
immediately and permanently delete this e-mail [shred the document] and
any attachments.





--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html


________________________________________________________________________
In order to protect our email recipients, Betfair use SkyScan from
MessageLabs to scan all Incoming and Outgoing mail for viruses.

________________________________________________________________________


Oracle LazyDBA home page