Date: Fri, 2 Jun 2017 10:29:22 -0700 (MST)
From: anand086 <anand086@gmail.com>
To: pgsql-sql@postgresql.org
Message-ID: <1496424562862-5964545.post@n3.nabble.com>
In-Reply-To: <1496367359721-5964400.post@n3.nabble.com>
References: <1496363048908-5964384.post@n3.nabble.com>
 <CAKFQuwZYqwvo+yxZGb9U=iciN5wC_+F_aim8_kZDPqfTEbekpw@mail.gmail.com>
 <1496367359721-5964400.post@n3.nabble.com>
Subject: Re: Using bind variable within BEGIN END
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

Another example where we are getting the same error is from the call of the
below code --


ctx.update(""
                                                                + "begin \n"
                                                                + "          
access.register_type( \n"
                                                                + "          
p_entity_system                 => ?, \n"
                                                                + "                          
p_entity_type                      => ?, \n"
                                                                + "                          
p_attribute_name             => ?, \n"
                                                                + "                          
p_creator_id                        => ?, \n"
                                                                + "                          
p_description                       => ? \n"
                                                                + " );"
                                                                + "end;",
                                                                systemName,
                                                                entityType,
                                                               
attributeName,
                                                                creatorID,
                                                               
attributeDescription);


access.register_type is a function 


CREATE OR REPLACE FUNCTION access$register_type"(
    p_entity_system text,
    p_entity_type text,
    p_attribute_name text,
    p_owner_id text DEFAULT NULL::text,
    p_sia_admin text DEFAULT NULL::text,
    p_ad_role text DEFAULT NULL::text,
    p_create_role numeric DEFAULT 0,
    p_description text DEFAULT NULL::text,
    p_creator_id text DEFAULT NULL::text)
  RETURNS void AS
$BODY$
 

--
View this message in context: http://www.postgresql-archive.org/Using-bind-variable-within-BEGIN-END-tp5964384p5964545.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql