agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: anand086 <anand086@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: Using bind variable within BEGIN END
Date: Fri, 2 Jun 2017 10:29:22 -0700 (MST)
Message-ID: <1496424562862-5964545.post@n3.nabble.com> (raw)
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
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
view thread (9+ messages) latest in thread
Message-ID: <1496424562862-5964545.post@n3.nabble.com>
Permalink: ../1496424562862-5964545.post@n3.nabble.com/
Also on: postgresql.org/message-id/1496424562862-5964545.post@n3.nabble.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: anand086@gmail.com
Subject: Re: Using bind variable within BEGIN END
In-Reply-To: <1496424562862-5964545.post@n3.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox