Published on InterSystems Developer Community (https://community.intersystems.com)

Home > "Insert into" using "stored procedure"

Question
Manu Jose · Sep 6, 2022

"Insert into" using "stored procedure"

How can we insert into a table using a stored procedure? 

Table structure :

CREATE TABLE SampleHospital (
    Hospital VARCHAR(50),
    Location VARCHAR(50),
    UserName VARCHAR(50),
       UserFullName VARCHAR(70),
       LastLogin TIMESTAMP,
       LoginCount int)

 

Procedure Name:

call Custom_MENS_Other.samplesp('2021-11-02','2021-11-04','H001')

#SQL #Caché
Product version: Caché 2018.1

Source URL:https://community.intersystems.com/post/insert-using-stored-procedure