From: | anand086 <anand086(at)gmail(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Using bind variable within BEGIN END |
Date: | 2017-06-02 17:29:22 |
Message-ID: | 1496424562862-5964545.post@n3.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-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.
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2017-06-02 18:21:40 | Re: Using bind variable within BEGIN END |
Previous Message | Tom Lane | 2017-06-02 16:07:17 | Re: Database views metadata always nullable columns |