Re: Insert into postgre database from a stored procedure

From: Lutz Horn <lutz(dot)horn(at)posteo(dot)de>
To: pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Re: Insert into postgre database from a stored procedure
Date: 2018-12-03 06:27:18
Message-ID: fd72ea88-76a9-e1ca-34f1-d218dcdb5ca1@posteo.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> I have C#&nbsp; application that uses Dapper as its ORM
>
> I am trying insert&nbsp; records into a postgresql database through a stored procedure
>
> I get a syntax error on&nbsp;&nbsp;cmd.ExecuteNonQuery();&nbsp; line

How is the stored procedure "public.spabsecode_insert" defined? Does it
accept the two parameters "absecodex" and "absedescx"?

Please show us the code of the stored procedure.

Lutz

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Helmut Dittenwald 2018-12-09 16:30:51 [libpq] Async Queries and the Order of Execution
Previous Message techsupport 2018-12-03 02:34:41 Insert into postgre database from a stored procedure