Re: [SQL] Using bind variable within BEGIN END - Mailing list 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)
RETURNSvoid 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.