Re: How to get response message

2022-06-10 Thread David G. Johnston
On Fri, Jun 10, 2022 at 9:38 AM Rama Krishnan wrote: > I am want to delete old records using function so my senior has function > like below but I want to get response of this particular inside query > wheter it is successful or failure > If it doesn't error, it was successful. That is basicall

Re: How to get response message

2022-06-10 Thread Francisco Olarte
On Fri, 10 Jun 2022 at 18:38, Rama Krishnan wrote: > > Hi All, > > I am want to delete old records using function so my senior has function like > below but I want to get response of this particular inside query wheter it is > successful or failure > How to get response of the function status

Re: How to get response message

2022-06-10 Thread Adrian Klaver
On 6/10/22 09:37, Rama Krishnan wrote: Hi All, I am want to delete old records using function so my senior has function like below but I want to get response of this particular inside query wheter it is successful or failure How to get response of the function status  create or replace fun

How to get response message

2022-06-10 Thread Rama Krishnan
Hi All, I am want to delete old records using function so my senior has function like below but I want to get response of this particular inside query wheter it is successful or failure How to get response of the function status create or replace function data_purge() returns void as$$ Declare