Forum OpenACS Development: Response to Does anonymous function creation handle single quotes properly?

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*