Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: plsql dynamic sql - weird error in repeated execution where contents differ in each loop
suggestion ...
/* original
execute immediate 'select '
|| sFunc || sThisColumn || sEndFunc || ' ' || 'from ' || sThisTable || ' ' || 'where ' || sThisColumn || ' ' || ' = :b1 'into sThisColumnValue
--You use sThisColumn 2 times, so You have to apply the function 2 times
also
--comments inline
execute immediate 'select '
|| sFunc || sThisColumn || sEndFunc || ' ' || 'from ' || sThisTable || ' ' || 'where ' || sFunc || sThisColumn || sEndFunc || ' ' || ' = :b1--and take care of the type of :b1, too ... into sThisColumnValue --... and what data type is this ? another possibility of type mismatch ...
hth, Jan
"M Buckle" <markbuckle30_at_hotmail.com> schrieb im Newsbeitrag
news:d3868cb5.0307310152.d1056c8_at_posting.google.com...
> I have a feeling i might know whats going on, but can any-one answer this
anyway ?
>
>
>
>
> >
>
>
> ....................
>
>
>
>
> >