Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL Dynamic SQL problem
Sorry about the previous post, the problem was due to a data error, code is
fine.
M.Casey wrote in message <7qgnrm$mc7$1_at_ezekiel.eunet.ie>...
>
>I am having a problem when executing some Dynamic Sql. (Oracle 7.3.4) on
>NT4.
>
>I have a procedure which normally inserts into the database but if it finds
>a duplicate primary key it should perform an update.
>
>The code actually goes into the update section , binds the values , appears
>to execute successfully, but when checking the database , the row has not
>been updated.
>
>
Received on Tue Aug 31 1999 - 10:38:14 CDT