Aha! Figured it out myself...either I hadn't tried every option
yet, or I screwed up something else when I tried the correct
one...*grin*. If I change the tcl call back to a db_exec_plsql, but
I leave the xql file as a begin; (note with
semicolon)/select...foo;/end;, the QD bypasses creation of the
anonymous function, and works properly. Success!
Hmmmm...that being said...what if I NEEDED the return value of
the function, and had to use the
declare
v_url_id integer;
begin
v_url_id := url__new (
:url_id,
:url_title,
:host_url,
:complete_url,
:meta_keywords,
:meta_description,
:viewed_user_id,
:creation_ip,
null
);
return v_url_id;
end;
format? With a bind variable that includes a single quote, can the
anonymous function be made to work, or does it always break?
Inquiring minds want to know...but as of now, I can get bookmarks
with apostrophes inserted, so I'm happy! *grin*