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.




Oracle LazyDBA home page