Sql Server Procs created using wbinclude is not reflecting in DB

Arunagiri M

unread,

Oct 26, 2021, 3:42:58 AM10/26/21

to SQL Workbench/J - DBMS independent SQL tool

Hi Team,

I have created a procedure in a remote db using workbench command line, when I run WbListProcs , I can see the proc but when I checked in the database it is not reflecting. Please help me to resolve this.

Thanks,

Arun

Thomas Kellerer

unread,

Oct 27, 2021, 2:35:30 AM10/27/21

to sql-wo...@googlegroups.com

Sounds as if you are not committing the CREATE PROCEDURE statement.

Either add the COMMIT or make sure you enable Autocommit in the connection profile.

Arunagiri M

unread,

Oct 27, 2021, 5:15:01 AM10/27/21

to sql-wo...@googlegroups.com

Thanks Thomas.

Regards,

Arun

--
You received this message because you are subscribed to the Google Groups "SQL Workbench/J - DBMS independent SQL tool" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sql-workbenc...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sql-workbench/71a35ccf-1c14-32b2-25d1-7eb8ba02c189%40sql-workbench.net.

Reply all

Reply to author

Forward