On 12/29/20 9:29 AM, Mark Johnson wrote:
Don't you have to select into a variable and then return the variable to
the client per [1]?
Except PROCEDUREs do not return things(INOUT excepted), it would need to
be a FUNCTION.
Consider the following example from my Oracle system:
beginning cod
Don't you have to select into a variable and then return the variable to
the client per [1]?
Consider the following example from my Oracle system:
beginning code ...
V_SQL := 'SELECT COUNT(*) FROM ' || V_TAB;
EXECUTE IMMEDIATE V_SQL INTO V_CNT;
ending code ...
[1]
https://www.postgresql.org/
On 12/28/20 10:34 PM, Muthukumar.GK wrote:
Pleas do not top post, the style on this list is bottom/inline posting.
Hi Adrian Klaver,
Sorry for typo mistake. Instead of writing lengthy query, I had written
it simple. Actually my main concept is to bring result set with multiple
rows (using sel
Hi Adrian Klaver,
Sorry for typo mistake. Instead of writing lengthy query, I had written it
simple. Actually my main concept is to bring result set with multiple rows
(using select query) with help of dynamic query.
When calling that procedure in Pgadmin4 window, simply getting the message
as
On 12/13/20 9:59 PM, Muthukumar.GK wrote:
Hi team,
When I am trying to implement belwo dynamic concept in postgreSql,
getting some error. Kindly find the below attached program and error.
Please advise me what is wrong here..
CREATE OR REPLACE PROCEDURE DynamicProc()
AS $$
DECLARE v_query
On Monday, December 14, 2020, David G. Johnston
wrote:
>
> On Sunday, December 13, 2020, Muthukumar.GK wrote:
>
>> Hi David,
>>
>> As I am not bit Clea, let me know what I have to do. If possible, please
>> re- write my program.
>>
>
> Like the SQL executor, I have no idea what you are trying to
On Sunday, December 13, 2020, Muthukumar.GK wrote:
> Hi David,
>
> As I am not bit Clea, let me know what I have to do. If possible, please
> re- write my program.
>
Like the SQL executor, I have no idea what you are trying to do there.
Neither the text variable, nor the cursor, nor plpgsql for
Not to be disrespectful, but you need to at least struggle to find the
answers yourself before posting here.
On Mon, Dec 14, 2020 at 12:02 PM Muthukumar.GK
wrote:
> Hi David,
>
> As I am not bit Clea, let me know what I have to do. If possible, please
> re- write my program.
>
> Regards
> Muthu
Hi David,
As I am not bit Clea, let me know what I have to do. If possible, please
re- write my program.
Regards
Muthu
On Mon, Dec 14, 2020, 11:43 AM David G. Johnston
wrote:
> On Sunday, December 13, 2020, Muthukumar.GK wrote:
>
>>
>> v_query := ' OPEN C1 FOR SELECT * FROM public."Bankdetail
On Sunday, December 13, 2020, Muthukumar.GK wrote:
>
> v_query := ' OPEN C1 FOR SELECT * FROM public."Bankdetails"';
>
>
>
> EXECUTE (v_query);
>
>
>
You put the pl/pgsql OPEN command into a string and sent it to the SQL
engine via EXECUTE and the SQL engine is complaining that it has no idea
wha
Hi team,
When I am trying to implement belwo dynamic concept in postgreSql, getting
some error. Kindly find the below attached program and error. Please advise
me what is wrong here..
CREATE OR REPLACE PROCEDURE DynamicProc()
AS $$
DECLARE v_query TEXT;
C1 refcursor := 'result1';
begin
v_q
11 matches
Mail list logo