tag:blogger.com,1999:blog-20612393.post8220013011069391509..comments2023-09-29T21:26:11.876+07:00Comments on Surachart Opun's Blog: Dynamic SQL: cursor: pin S wait on XSurachart Opunhttp://www.blogger.com/profile/05646896104906516714noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-20612393.post-46396691020212147332009-11-05T09:04:59.782+07:002009-11-05T09:04:59.782+07:00Just issue("cursor: pin S wait on X" hig...Just issue("cursor: pin S wait on X" high) to concern, when use Dynamic SQL.<br />And avoid to use it(Dynamic SQL).Surachart Opunhttps://www.blogger.com/profile/05646896104906516714noreply@blogger.comtag:blogger.com,1999:blog-20612393.post-7800443850764537872009-11-05T03:06:29.870+07:002009-11-05T03:06:29.870+07:00Interesting topic. Would the following proc even b...Interesting topic. Would the following proc even better?<br /><br />create or replace procedure proc_C (obj_id IN number)<br />is<br />v_c number;<br />begin<br /> select count(*) into v_c from TMP01 where object_id = obj_id;<br /> dbms_output.put_line(v_c);<br />end;<br />/<br />- Denisydshttps://www.blogger.com/profile/15884036034395020134noreply@blogger.com