tag:blogger.com,1999:blog-1561253375800464394.post5227352115425304928..comments2024-03-28T10:48:36.635+01:00Comments on Denes Kubicek ApEx BLOG: ApEx - Replacing Binds ProcedureDenes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-1561253375800464394.post-21661969066704211202008-07-07T11:07:00.000+02:002008-07-07T11:07:00.000+02:00Hi Denes,I've recently began working with ApEx her...Hi Denes,<BR/><BR/>I've recently began working with ApEx here at our company (so I'm still learning at the moment) and I came across this post of yours while browsing ApEx blogs.<BR/>Isn't it easier to just concatenate your :P_ITEM variables in your query at runtime instead of transforming them.<BR/>The way I used it to build my collection was to just concatenate the query like this (this is just a little code from the where, the full query is rather big): <BR/>...<BR/>dh.doccode not like ''DISPERSE'' and<BR/> dh.cmpcode = ''' || to_char(:P2_SEARCH_COMPANY) ||''' and<BR/> e.code like ''' || to_char(:P2_SEARCH_FILE) || ''' and<BR/> dl.el2 like ''40%''<BR/> GROUP BY<BR/>...<BR/><BR/>It seems to work fine this way around (you just need to escape your ' with another ' in the query).<BR/><BR/><BR/>Greetz and love your blog,<BR/>CamstraAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-38659708346134963672007-05-18T11:45:00.000+02:002007-05-18T11:45:00.000+02:00Is there any critical issue with GOTO, except it i...Is there any critical issue with GOTO, except it is "outdated"? This was my favorite from the times of fortran.<BR/><BR/>Denes KubicekDenes Kubicekhttps://www.blogger.com/profile/01962373591521960882noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-41446109314929237392007-05-18T08:37:00.000+02:002007-05-18T08:37:00.000+02:00Hi Denes,looks like that your code got corrupted, ...Hi Denes,<BR/><BR/>looks like that your code got corrupted, when you pasted it. Your goto label is missing.<BR/><BR/>But honestly, I would avoid using GOTO in programs, you can also use a<BR/>LOOP<BR/> EXIT WHEN [...]<BR/>END LOOP;<BR/>instead too. Much nicer.<BR/><BR/>PatrickPatrick Wolfhttps://www.blogger.com/profile/16652802762749621200noreply@blogger.com