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')

Product version: Caché 2018.1
0
0 117
Discussion (2)1
Log in or sign up to continue

Yes. It's got worked. Thanks smiley