tag:blogger.com,1999:blog-37621059.post2015603813791401187..comments2007-04-26T10:44:10.704-07:00Comments on Kris' blog: Interactive Reports part 2Kris Ricehttp://www.blogger.com/profile/01592459412450086148noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-37621059.post-76051882576890932962007-04-26T10:44:00.000-07:002007-04-26T10:44:00.000-07:00is OBJECT_NAME a column in your query? For contex...is OBJECT_NAME a column in your query? For context menus, it only know of what is in that query. There's no way right now to select a column and hide it.<BR/><BR/>-krisKris Ricehttp://www.blogger.com/profile/01592459412450086148noreply@blogger.comtag:blogger.com,1999:blog-37621059.post-52745465243464253502007-04-17T13:42:00.000-07:002007-04-17T13:42:00.000-07:00Hi,I cannot get it to work.v_name varchar2(200) :=...Hi,<BR/>I cannot get it to work.<BR/>v_name varchar2(200) := '#OBJECT_NAME#';<BR/><BR/>object_name is not replaced.<BR/>Another question: is there anyway to select a column in the query for a tab, but not show it on screen?<BR/><BR/>thanksGhassanhttp://www.blogger.com/profile/16146970373384214775noreply@blogger.comtag:blogger.com,1999:blog-37621059.post-49355051248244251212007-04-16T13:50:00.000-07:002007-04-16T13:50:00.000-07:00I never made it smart enough to do that. Instead ...I never made it smart enough to do that. Instead you cane use the #OBJECT_NAME# for string substitutions. So something like this.<BR/><BR/>declare<BR/> v_name varchar2(200) := '#OBJECT_NAME#';<BR/>begin<BR/>....<BR/>end;<BR/>/Kris Ricehttp://www.blogger.com/profile/01592459412450086148noreply@blogger.comtag:blogger.com,1999:blog-37621059.post-73012023133254017442007-04-13T14:35:00.000-07:002007-04-13T14:35:00.000-07:00Kris,it's me again. I've generated an 'editor' ext...Kris,<BR/>it's me again. I've generated an 'editor' extension using this 'report' way. I'm adding a contextual menu item. It displays very well, but how do I access the OBJECT_OWNER and OBJECT_NAME in the 'item' code? I'm using :OBJECT_OWNER, but it's giving me an error "missing In or OUT parameter at index:: 1". Any idea?<BR/><BR/>thanksGhassanhttp://www.blogger.com/profile/16146970373384214775noreply@blogger.com