Calling stored procedure from lb4

22 views
Skip to first unread message

Mayur saner

unread,
Jan 19, 2021, 7:53:58 AM1/19/21
to LoopbackJS
I have stored procedures in PostgreSQL, I want to call it from connector and I have tried this,

  return this.leavemasterRepository.dataSource.execute(
      "CALL public.AddLeave(1,'2020-12-03', '2020-12-06', 4,'Pending By SP','Pending','2020-12-03',4,'55',24," +
      test +
      ')')

But I doesn't work because from Add Leave stored procedure I am adding data in 3 tables. And here I have given repository for only one table, i.e. leavemasterRepository.
Any solution over this?
Reply all
Reply to author
Forward
0 new messages